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

Latest Blog Posts

SQL in the City Seattle 2015

Redgate will be hosting another SQL in the City event on the Monday right before the PASS Summit 2015.  This is a free all day event that you can take advantage of by coming into town a little early.  The event will feature some of the best speakers and SQL… Read more

10 comments, 36 reads

Posted in Ryan Adams on 4 August 2015

Machine Learning Data Sets

Machine Learning Data Sets

When starting out with data mining and machine learning you will need to have access to sample data in order to learn the technology.  Often times leveraging data outside of your corporate data sets makes it easier to learn.  There is a large collection of sample… Read more

0 comments, 45 reads

Posted in Business Intelligence and Enterprise Architecture on 4 August 2015

SSC Editorial: How to Keep Up with SQL Server

How to Keep Up With SQL Server ran as the editorial of the day on July 31st. Modest amount of comments, but in particular I made a note to come back to the topic of early adopters vs being stuck with a late/never adopting employee. Both are interesting scenarios.

Imagine… Read more

0 comments, 45 reads

Posted in SQLAndy on 4 August 2015

I’m Speaking! SQL Saturday #402 – Indianapolis

One of benefits, among several, in moving to Kentucky is the close proximity to several SQL Saturday events.  I am honored to have been selected to speak at SQL Saturday #402 in Indianapolis, Indiana. Indianapolis is a great town and I’m looking forward to attending my 4th SQL Saturday Read more

0 comments, 40 reads

Posted in John Morehouse | Sqlrus.com on 4 August 2015

How many errors can the PowerShell error buffer hold?


During my presentation at SQL Saturday Albany I was asked a question about the error buffer that I didn’t know the answer to. The question was, “How many errors can the error buffer hold?” and I really had no idea. I had a few minutes after the presentation and decided…

Read more

0 comments, 42 reads

Posted in cjsommer.com on 4 August 2015

Credentials and Proxies: Getting Started

If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a login is.  However, did you know that you can access resources outside of SQL Server without granting the login permissions everywhere, and also run job steps under accounts that don’t… Read more

0 comments, 60 reads

Posted in Adam Kreul | Blog on 4 August 2015

My favourite books

As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the Belgian SQL Server Days. There is a Speaker in the Spotlight section on the site, where a speaker can introduce him/her self by answering a simple survey. One… Read more

0 comments, 42 reads

Posted in Koen Verbeeck on 4 August 2015

The Seven-Day Weekend by Ricardo Semler

This great book by Ricardo Semler is something that some of my friends have been recommending me to read for years. I have constantly have heard that I would find enough reflections of my thoughts and my character in it,…

Read more

0 comments, 69 reads

Posted in Niko's blog on 4 August 2015

Table Size Script Update for 2015

As was recently promised, I have an update to an old tried and true script for calculating the size of an object.

That promise was doled out in the previous article when I discussed the internal table types. You can read the article here. Information from that article was… Read more

2 comments, 57 reads

Posted in SQL RNNR on 4 August 2015

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, 120 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, 128 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, 94 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, 87 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, 52 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, 74 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, 66 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, 63 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, 73 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)
select…

Read more

0 comments, 52 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, 63 reads

Posted in Todd McDermid's Blog on 3 August 2015

Older posts