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

Latest Blog Posts

Monday Morning SQL Break – May 23, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

0 comments, 84 reads

Posted in StrateSQL on 23 May 2016

Monday Morning SQL Break – May 16, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

0 comments, 78 reads

Posted in StrateSQL on 23 May 2016

PASS Board 2016: Update #3

I didn’t post an update last month, but I did do something more important: I elicited your feedback on a question the Board needs to act on.

Here’s what I’ve been up to.

First, based on your feedback (thanks) and conversations that I’ve had with members of the Board, I’m… Read more

0 comments, 107 reads

Posted in The Scary DBA on 23 May 2016

Master_Views: master_objects, master_tables, etc

There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of all files from all databases. It’s been somewhat frustrating to me that there is no similar master_objects, master_tables, master_indexes etc. So what does a dev/dba do? Create them! So… Read more

0 comments, 95 reads

Posted in SQLStudies on 23 May 2016

The Road to SQLSaturday Orlando – 2016

This year I’ll blog sporadically on the event, focusing on pain points, discoveries, and new ideas with the occasional progress report.

  • Requesting the event # is much better than the last time I did it (years ago). More of a wizard, lets you set the exact location (though it’s a…

Read more

0 comments, 87 reads

Posted in SQLAndy on 23 May 2016

How Do I Change My Domain Password on Windows Server 2012?

As a DBA I spend a lot of time in RDP sessions, both to SQL Servers and to "jump"/pass-through servers on client domains.  Most clients (unfortunately not all of them - security is important, people!) have some variant of password expiration in their domains requiring regular password changes every 30/90/180…

Read more

0 comments, 78 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 May 2016

Which method is best to import data from Oracle database to SQL

Hi Guys,

I would like to start a discussion through my blog to know more about this topic.

Below options I know to import data from Oracle to SQL..

1) Import/Export
2) Linked Server (Using OpenQuery)
3) SSIS Packages

The fastest among these 3 I noticed is the 3rd one…

Read more

0 comments, 145 reads

Posted in SQL Articles by Nani on 22 May 2016

Identity increment is jumping in SQL Server database

Please look at the below screenshot to understand what jumping of identity value is (It is taken from SQL 2014 Database table.)

Observe records below the red line..the identity value jumped from 17 to 1014 and started continuing from there.

Cause: This is not actually the issue or bug. It…

Read more

2 comments, 165 reads

Posted in SQL Articles by Nani on 20 May 2016

SQL Server Random Workload Generator

Hello Dear Reader!  Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog).  He’s an Microsoft Data Platform MVP, MCM,  part of the amazing crew over at SQLSkills, and a really nice guy.  

About 4 years ago Jonathan created The AdventureWorks2008R2…

Read more

0 comments, 179 reads

Posted in SQLBalls on 20 May 2016

SQL Server Exercise for Data Warehouse Candidates


Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire competent and reliable people. We recently had to fill a data warehouse position in our team and I setup the following technical exercise that helps measure technical competencies… Read more

0 comments, 195 reads

Posted in Select SIFISO Blogs on 20 May 2016

SQLSaturday Pensacola Up Next For Me, Baton Rouge on the Horizon

Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been in the past a pilgrimage that the wife and I enjoyed in early June, and we'll both be there again now that the event is returned for the first…

Read more

0 comments, 134 reads

Posted in SQL Tact on 20 May 2016

Bad Data Can Kill

Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business, where estimates of total losses are usually gauged in the hundreds of billions of dollars per year. Nor am I talking about the inconvenience we all face when presented with… Read more

0 comments, 169 reads

Posted in Tim Mitchell on 20 May 2016

SSRS 2005 Bug - Percentage calculated column when Exporting to Excel

Nature of the Issue Faced :- Say you have 3 columns in a tablix/table on the report. There are 3 textboxes in each of these columns. Let us give them names as textbox1, textbox2 and textbox3.
Textbox3 should be textbox1 - textbox2. We are using following formula to achieve this…

Read more

0 comments, 95 reads


Speaking about Power BI @ ITPROceed 2016

I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this event, it’s an IT Pro focused event in Belgium about Microsoft Technologies. And what’s even better, it’s totally free.

My session will be a general overview of what you… Read more

0 comments, 148 reads

Posted in Koen Verbeeck on 19 May 2016

StorSimple Appliance – Part 1 Overview

Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance (which you can find here and here). I notice some others are looking at the same and would like to share more information on this device and the test…

Read more

0 comments, 390 reads

Posted in Dennis's SQL Blog on 19 May 2016

Changing a Computed Column–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I was working with a computed column the other day, and realized I had the wrong definition. In this case, I was performing some large calculation, and… Read more

0 comments, 219 reads

Posted in The Voice of the DBA on 19 May 2016

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, 801 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, 120 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, 629 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, 194 reads

Posted in SQL Awesomesauce on 18 May 2016

Newer posts

Older posts