Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Broken Update With Join

Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see fairly regularly when reviewing code. This month I’m covering UPDATE statements that run into trouble because of JOINs.

Updates with joins are not covered by the ANSI standard. To see… Read more

0 comments, 1,007 reads

Posted in The Database Avenger on 18 May 2016

Table changes not automatically reflected in a SQL Server View

For example you have added new columns to the tables which are used by SQL view. Nothing is changed in the view but when you execute the view or any other object which is using the view you will see columns not found error message.

To fix that, we need…

Read more

0 comments, 121 reads

Posted in SQL Articles by Nani on 18 May 2016

Migrate from on-prem SQL server to Azure VM IaaS

Hopefully you went through my presentations Should I move my database to the cloud?Introducing Azure SQL Database and Implement SQL Server on an Azure VM and are convinced to move your databases to the cloud.  If you are going to migrate to Azure SQL Database and want more… Read more

1 comments, 800 reads

Posted in James Serra's Blog on 18 May 2016

Minion CheckDB Beta

Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is the time. We’re putting the finishing touches on the 1st beta and it’s looking great with some fabulous features. So this is the open call for beta users. If you’d…

Read more

3 comments, 198 reads

Posted in SQL Awesomesauce on 18 May 2016

Re-Evaluating Best Practices

I was reading a blog post from my friend Randolph West (b/t) on Best Practices and a thought struck me.

Starting with Randolph’s definition of a best practice (he got it from Wikipedia and it’s more than good enough)

A best practice is a method or…

Read more

4 comments, 144 reads

Posted in SQLStudies on 18 May 2016

MongoDB : Point in Time Restore/Recovery of MongoDB

This post demonstrates the methods of PIT recovery of the database. The step by step details of the recovery process is explained below

The requirement for PIT restore/recovery is to setup a single node replica so that the oplogs can be used to “replay transactions” for point in time recovery.… Read more

0 comments, 158 reads

Posted in PowerSQL By Prashanth Jayaram on 17 May 2016

Catching Up on The #SQLPASS Virtual Chapters

(Didn't realize until I was posting that this was my 100th post...whew!)


A few months ago we purchased a new "smart" Blu-Ray player and one of its intriguing features was its built-in WiFi with pre-installed Internet apps like Amazon Video, YouTube, Vudu, etc. (Previously we had a 6-year-old "dumb"…

Read more

0 comments, 173 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 May 2016

MDW Data Collector – Collection Set jobs not working


Error Message 1 :

Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS – Read Current Upload Data [1], Description: String too long. The adapter read a string that was 50331648 bytes long, and expected a string no longer than… Read more

0 comments, 158 reads

Posted in MSSQLFUN on 17 May 2016

10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )

This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good friend, Mitch Pearson (blog | twitter) and I presented our session, Designing a Data Warehouse from the Ground Up. We had a great crowd and lots of great… Read more

4 comments, 3,353 reads

Posted in SQL with Dustin Ryan on 16 May 2016

Query Store, Forced Plans, and New Plans

I love questions. I recently received one about new plans in the Query Store (available in Azure SQL Database now and in SQL Server 2016 after June 1).

Let’s say you have selected a plan that you want to force. You set it up. Now, let’s say the plan ages… Read more

3 comments, 827 reads

Posted in The Scary DBA on 16 May 2016

RAID your backups

Let’s start with a very brief definition of some RAID levels.

  • RAID 0 : Stripe your data across multiple disks. Writing a portion of the data to each disk. This improves performance but increases the risk of corruption.
  • RAID 1 : Mirror your data across multiple disks. This duplicates…

Read more

6 comments, 921 reads

Posted in SQLStudies on 16 May 2016

Continual Deployment of Visual Studio SqlProj

Unveil the inner workings of the esoteric build system...

As a data professional, I've never worked extensively with msbuild or other pipelines. I'd been mostly focused on just running schema comparisons and publishing. However, I've had the needed to try and deploy a database project from visual studio automatically, and… Read more

0 comments, 163 reads

Posted in SQL Barbarian on 16 May 2016

DBA Database scripts are on Github

It started with a tweet from Dusty

The second session I presented at the fantastic PowerShell Conference Europe was about using the DBA Database to automatically install DBA scripts like sp_Blitz, sp_AskBrent, sp_Blitzindex from Brent Ozar , Ola Hallengrens Maintenance Solution , Adam Mechanics sp_whoisactive , This fantastic script for… Read more

0 comments, 231 reads

Posted in SQL DBA With A Beard on 16 May 2016

SQL Server – Change in Identity() Property during transactions

Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on …

Continue reading Read more

0 comments, 214 reads

Posted in Kapil Blogs on 16 May 2016

Alwayson Availability Groups vs Alwayson Failover Cluster Instances

SQL Server is one of the finest database management system deployed by organizations for storing and retrieving their data. It facilitates the function of data storing and retrieving by the applications which either run on the same or different platforms. The dominant reason behind the deployment of SQL Server on… Read more

0 comments, 1,096 reads

Posted in Zora's SQL Tips on 16 May 2016

Tempdb Metadata Contention in SQL Server – Table Variable Vs Temporary Table

In SQL Server, the concurrent creation of temporary tables from many sessions can lead to tempdb metadata contention. Tempdb metadata contention does not affect the concurrent creation of table variables.

When SQL Server creates temporary tables, it has to update metadata information in the system based tables, like sys.sysschobjs (like… Read more

AlwaysOn Availability Groups Synchronous Replica Readable Secondary Data Access Latency

With SQL Server AlwaysOn Availability Groups, when you configure a secondary in synchronous-commit mode for read-only access, there can be data access latency.

If you make changes to your data like if you perform insert, update or delete in primary, those changes may not be visible in the secondary, synchronous… Read more

Seek or Scan – Cost Based Optimizer in SQL Server

When SQL Server has a choice of plans, it will compare the cost among a set of execution plans and will choose the cheapest one.

In some cases, even though the cost of seek is slightly higher than the cost of scan, SQL Server Optimize might still choose a seek… Read more

Optimize for Ad Hoc Workloads – SQL Server Configuration Parameter

SQL Server configuration parameter “optimized for ad hoc workloads” can be very useful when you execute lots of single use ad hoc statements or dynamic SQL statements by reducing memory usage of plan cache. If the majority of ad hoc statements or dynamic SQL statements execute more than once, then… Read more

Newer posts

Older posts