Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Start SQL Server in Single User Mode

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

I saw someone recently ask how to reset the sa password, and myself (along with a few others) suggested starting SQL Server in single user mode as an… Read more

0 comments, 66 reads

Posted in The Voice of the DBA on 3 August 2015

Clearing Out a Database With SQL Compare

I ran into a question recently about how to clear out a database of all objects. I assume someone was testing some type of deployment scenario, and didn’t want to drop the database, but rather just remove objects and redeploy.

I know SQL Compare could do this, so I mocked… Read more

0 comments, 75 reads

Posted in The Voice of the DBA on 3 August 2015

Using the DAC

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

The DAC is a really important tool for anyone managing a SQL Server. You might not use it often, but when you need it, you really need it.… Read more

0 comments, 60 reads

Posted in The Voice of the DBA on 3 August 2015

SQL Server – Sparse Column Property using SELECT INTO

Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different …

Continue reading Read more

0 comments, 59 reads

Posted in Kapil Blogs on 3 August 2015

Monday Morning SQL Break – August 3, 2015

It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post 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 blog.  If you haven’t already, follow… Read more

0 comments, 33 reads

Posted in StrateSQL on 3 August 2015

Differences Between Actual & Estimated Plans

I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The primary reason for this is to get the Actual Plan in order to see the differences between the Actual and Estimated Row Counts as a means of understanding how the… Read more

0 comments, 52 reads

Posted in The Scary DBA on 3 August 2015

SQL Crossword

I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF versions at the bottom.)

Download the crossword as a Word file.
Download the crossword as a PDF

Filed under: DBA Humor, Microsoft SQL Server, SQLServerPedia Syndication Tagged: Humor

Read more

0 comments, 49 reads

Posted in SQLStudies on 3 August 2015

Downloading SFTP Files with SSIS

If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to download a file stored on an SFTP (secure FTP) server, but SSIS does not natively support this operation. There is a built-in FTP task in SSIS, but it is very… Read more

0 comments, 42 reads

Posted in Tim Mitchell on 3 August 2015

Single instance vs. multiple instances of SQL Server on a server

Let`s consider a situation when you need to build a server with SQL Server used by multiple client applications. Here are two options to consider.

  • Single instance that host ALL the databases

  • Multiple instances with each having subset of the databases.

We`ve created a table with comparison of these two… Read more

0 comments, 56 reads

Posted in Forrards Group Database Blog on 3 August 2015

Question of the Month (July)

Suppose we have a table emp_plan  which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-

Create table emp_plan (empid nvarchar(200),planid nvarchar(20),startdate datetime, enddate datetime)

Also below is the script to enter sample data into the table:-

insert into emp_plan(empid,planid,startdate,enddate)

Read more

0 comments, 40 reads

Posted in Vivek's SQL Notes on 3 August 2015

Consolidating Multiple Data Marts

One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering.  The BI group at CHC used to assign specific people to specific business units in order to deliver solutions to business needs.  The upside of that arrangement was that each…

Read more

0 comments, 45 reads

Posted in Todd McDermid's Blog on 3 August 2015

Windows 10 Upgrade on Surface Pro 3 – Sending email issue FIXED

I very rarely blogabout anything other than SQL Server but felt that with a lot of the SQL Community using SP3’s that this may actually be helpful to some.

After playing around in a VM for a while now I decided to upgrade my SP3 to Windows 10 which comes… Read more

0 comments, 71 reads

Posted in Chris's SQL Blog on 2 August 2015

SQL Server GEEKS Annual summit 2015

Last month, I have requested my manager for an approval so that I can attend SQL Server Geeks Annual Summit 2015,  and now  when I hear back from him, I am really very excited that I will be attending.

You must be wondering what is so exciting about this Summit… Read more

Monday Morning SQL Break – July 27, 2015

It’s past time for the Monday blog and twitter round-up for last week, but better late than never (or not). 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… Read more

0 comments, 73 reads

Posted in StrateSQL on 2 August 2015

Beginning T-SQL slide deck and recording – #SQLSatBR

I had a great time in my Beginning T-SQL presentation here at SQL Saturday Baton rouge! Here is the BeginningTSQL slide deck (PDF). Here is an older recording of the class, as I haven’t yet had time to process today’s recording. Thanks to those who attended! Remember: SQL Server Books…

Read more

1 comments, 108 reads

Posted in SQL Awesomesauce on 1 August 2015

014 -Kon Melamud - WaterOx Consulting

Reading Time: 2 minutes

Kon!!!!!! In WOxPod!, episode # 014 – “Kon Melamud” Today we have...

The post 014 -Kon Melamud appeared first on WaterOx Consulting.

Read more

0 comments, 128 reads

Posted in WaterOx SQL on 31 July 2015

SQL Server Infernals – Circle 6: Environment Pollutors

Don’t tell me that you didn’t see it coming: at some point, Developers end up being put to hell by a DBA!

I don’t want to enter the DBA/Developer wars, but some sins committed by Developers really deserve a ticket to the SQL Server hell. In particular, some of those… Read more

0 comments, 103 reads

Posted in SpaghettiDBA on 31 July 2015

Migration of a large enterprise from SQL Server 2000 to 2014. Real life case.

This is a first article in a series of articles about real life database and IT infrastructure migration project which has been executed for a large US company which services are heavily dependent on fast and reliable database infrastructure. In this article we`ll give a brief description of the project,… Read more

0 comments, 134 reads

Posted in Forrards Group Database Blog on 31 July 2015

Whats new in SQL Server 2016

While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with great new advance features and stable SQL Server(just like after 2005 to SQL Server 2008). To learn more about SQL … Continue reading

Read more

0 comments, 128 reads

Posted in Vinay Thakur on 31 July 2015

SQLSaturday Dallas Precons Community Choice

The North Texas SQL Server User Group Board of Directors has decided to do something a little bit different for selecting Precons for our next SQLSaturday.  The SQLSaturday event will be held on October 3rd with the precons on October 2nd.  We have decided that since it is the community… Read more

0 comments, 87 reads

Posted in Ryan Adams on 30 July 2015

Older posts