 | A community of more than 1,600,000 database professionals and growing |
| Featured ContentsFeatured Script |
| | The Relentless Cloud The march to the cloud is inevitable. No, I don't think all your services will be run from a cloud service, but I do think that some of them will be. Maybe 10% for your company, maybe 90%, but likely somewhere in between. In the efforts to reduce costs, and maybe more likely, the idea of shifting costs to expenses, I would bet that most organiztions will take serious looks at the cloud in the next decade for a significant portion of all new services. They might not move most applications, but they'll think about it. I saw a note recently on Geekwire that Azure is estimated to exceed Amazon Web Services (AWS) by 2019. Most of us might not care about the race between these two tech giants to build large cloud infrastructures, but their capital expenditure is based on the idea that your organizations will want to use some of those services. They have good reasons to think this with surveys and conversations with many of their customers. In the absence of changing tax policy in many nations, it also makes more sense to make move costs to expense, rather than capital expenditures. And that's the way things are going, at least according to what CIOs are saying. More and more applications and services will be moving to the cloud in the next few years. Up to 30% from the current 14% of applications today. As I've seen more and more entreprises, public and private, moving mail and web services to outsourcing providers like O365, I also think we'll see other applications moving. I don't think every application is suited to an outsourced area, but I do think there's a case to be made for many of them, including databases. For those with privacy or security issues, cloud providers are working to mitigate the issues. Amazon has built separate data centers for government services, and I believe Azure is (or has) done so as well. The challenges that exist can be solved, and many of the risks or concerns will be mitigated, though you'll still need to evaluate your situation on a case by case basis, which will change over time. My recommendation: learn about the cloud. Really learn, don't just assume you know. It will be good for your career. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.9MB) podcast or subscribe to the feed at iTunes and Mevio .  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.  |
|
|
|
| | ADVERTISEMENT |  | | Want to include your database in your ALM processes? With Database Lifecycle Management, you can add your database to your source control, continuous integration, and release management processes, to reduce risk and improve efficiency. See how with this free whitepaper. |
|  | | How to fix SQL Server disk I/O bottlenecks (without a hammer) In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now. |
|  | | Write SQL effortlessly in SQL Server Management Studio 2016 and Visual Studio 2015 SQL Prompt puts SQL code completion, formatting, code snippets and more at your fingertips. For more quick tips on writing SQL effortlessly and speeding up your coding, watch our short videos. |
|
|
|
| | |
 | Press Release from Redgate Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". More » |
 | Additional Articles from SQLPerformance.com Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue. More » |
 | MUTHUKKUMARAN KALIYAMOORTHY from SQLServerCentral Blogs Whoisactive stored procedure is a powerful script to capture the SQL server queries with tons of information. It’s written by... More » |
| | Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Dot Plot Power BI Custom Visual. The Dot Plot is... More » |
|
|
| | | Today's Question (by Steve Jones): If I wanted to get a copy of my production database with all objects and the statistics for indexes, how can I do this in the easiest way in SQL Server 2014 SP2 and later? |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: DBCC. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| Yesterday's Question of the Day |
| | |
| | | himanshu.sinha from SQLServerCentral.com Lately I have been working in a role where I had deploy SQL bits on many instances and i found it boring and monotonous to this task and so I did wanted a smarter way to handle the situation . I have been a big fan of powershell and so I wanted to use this . The idea was to write a function and pass the servername/instance name with the query which I wanted to run against the server . Just sharing the function so that peeople can use it or guide me to a better solution (if any ) . The example in the last line does talk about the backup command , but any valid SQL command can be used ( insert , Update & delete ). More »
|
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
CHECKDB found 0 allocation errors and 21 consistency errors in table - Hi, I had one of my DB has some corruption. Looks like, need to restore from backup. I have a good...
T-SQL formatting tool - Does anyone know of a t-sql formatting tool that is compatible with SSMS 2016 and will format BACKUP/RESTORE statements? I've got...
Odd! Objects Shown Up in Master after DB Restoration - I created a script to restore multiple databases in one shot. What's weird is, I often see objects from the... Allocation and Consistency Errors - Hi all! I am not a DBA per se, but I do have enough experience with SQL to get assigned...
Exporting Database tables to Text at the same time - I have around 2000 tables i need to export to text files. I tried using the Export Wizard which works... Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script - Hi - I have a need to stop some application services based on the database environment I am refreshing, restore full... Execution plan differences in QA and Prod - I am run into an situation with a change in behavior to one query, and I'm looking for advice on... Junk Dimension Design - Hello Eveyone, I am struck with Junk dimension. My target table structure is as below. Junk_Dim ---------- JunkID -- PK JunkTypeID -- PK JunkCode JunkName JunkTypeName Below values need to be...
TEMPDB LOG explosive growth - twice in the last week the tempdb LOG has filled it's disk. i've never had an issue with the LOG... Correct MAXDOP setting - Hi All, I have a VM with 32GB RAM and 12 processors (SQL 2012 SP3 Ent 64bit) What would be the correct... Determine the license of an existing SQL Server 2012 installation - Out product is based on SQL Server 2012 and comes with a core license or with a server+CAL license (based...
need t-sql query - Hello All Need a tsql query in sql server 2012 for the below. We have a table with parent_id and child_id.Need to...
Stored procedures and Creating tables. (Problem). - Hello All, In a single store procedure I often have a number of functions: Initialize, Prepare something (for example the creation of a... Set up a linked server - I am trying to set up linked servers to four Excel spreadsheets. I am using SQL Server 2008 R2 and... Odd (to me) Behavior with NTILE() and NULL Values in Source Data - I just discovered the hard way (on 2005, replicated on 2008R2) that, if you compute NTILE() on a column of...
User (db_datareader) can't see tables in MS; can SELECT data! - We have an Acitve Directory user that is assigned db_datareader for a given database. Given any table name in the...
How do I create a new database using Backup? - I'm trying, once again, to get my database into Azure. I've gone through the process of creating a new logical...
Execution Plan -- Clustered Index Update - When looking at the execution plan of a query it shows a [b]'Clustered Index Update' [/b]@ a cost of 85%....
Restore wait for ASYNC_IO_COMPLETE unending - I'm trying to restore a 66 Gb database from a single backup file. The restore is lasting over 1 hour...
Transactional Replication - Snapshot is not getting applied to subscriber - Need Help: I have looked everywhere but I cannot find help for this specific topic. Any help to pinpoint the problem... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
