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

Latest Blog Posts

Networking at the PASS Summit

The 2014 PASS Summit is coming up in a few weeks and thousands of SQL Server professionals will be coming to Seattle for the event. Many will arrive early, and many will be there for the first or second time in their careers.

Many of them will be that guy Read more

1 comments, 3,875 reads

Posted in The Voice of the DBA on 15 October 2014

Upcoming conferences end of 2014: Microsoft Technical Server Summit, MVP Summit, PASS Summit, Microsoft Technical Summit


Das Jahresende nähert sich in raschen Schritten. In den nächsten 3 Monaten stehen wieder mehrere Konferenzauftritte an.

The end of year is approaching fast. For the next three months, several conferences are scheduled.

Nach der Vorstellung des SQL Server 2014 (SQL Server 2014 - Highlights in…

Read more

0 comments, 410 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 15 October 2014

SSIS Pivot makes you stronger

At the recent Toronto SQL Server User group meeting Michal J Swart (@MJSwart) gave a good presentation based on 10 of his blog posts. There was one (Forget About PIVOT, You Don’t Need It) that got my attention; first, I remembered that I had read…

Read more

0 comments, 119 reads

Posted in Data Adventures on 15 October 2014

PASS Election Results for 2014

The election results were just posted. Congratulations to James Rowland-Jones, Wendy Pastrick, and Grant Fritchey for earning seats on the PASS Board of Directors for the 2015-2016 term. This will be the second term for both James & Wendy, so both will be building on two years hard won experience… Read more

0 comments, 103 reads

Posted in SQLAndy on 15 October 2014

Lync 2013 Video Issues on Windows 8

Part of the reason I have a blog is to document issues and resolutions I do not want to forget. Yesterday morning I was on two calls using Lync and the video was blank or white. I had great audio and messaging worked fine. So the only part that was… Read more

0 comments, 87 reads

Posted in DataOnWheels on 15 October 2014

Thank You: #passvotes

The results are in and it seems that I’ve been elected to a place on the PASS Board.

Thank you.

I will strive to be worthy of the position you’ve placed in my hands. I will do my best to make a difference on the board. Watch this space for… Read more

8 comments, 96 reads

Posted in The Scary DBA on 15 October 2014

Tracking down CPU spikes using process explorer and DMVs

What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just shutting down the last applications when a call or a… Read more

2 comments, 4,688 reads

Posted in Ctrl-alt-geek on 15 October 2014

Can’t Create A Timeline in Excel on Multidimensional Cube

Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.

After getting excited about the Timeline object in Excel 2013, I tried to add this cool feature of Excel 2013 and got an error – “We can’t create a Timeline… Read more

0 comments, 86 reads

Posted in The Smiling DBA on 15 October 2014

Hell No, DMO - DMV is what it shall be!

So, I've finally decided to draw a line in the sand.  I've been doing some writing lately.  The radio silence will soon be broken in a big and "healthy" way.  In the meanwhile, I've got caught up in naming antics, and what we should really be calling them. There may… Read more

0 comments, 110 reads

Posted in Pearl Knows on 15 October 2014

An Introduction To SQL Server Data Mining Algorithms

What is Data Mining in General?

Data mining helps organizations having large sized database to explore their data in a simple and interactive way. It used to find patterns of the data and performs predictions on the process like a transaction on the server will succeed or not. It provides…

Read more

0 comments, 128 reads

Posted in Zora's SQL Tips on 15 October 2014

Murder In Utah

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it… Read more

0 comments, 90 reads

Posted in SQL RNNR on 14 October 2014

T-SQL – Scripting Stored Procedure to Create backup copy on same database

This post is one of the request from OP.

Download SQL  Backup SP in the same database

The probelm statement 1:-

Create a backup copy of a group of stored procedures on the same database.  Using TSQL I need to find all stored procedures that meet a criteria (WHERE… Read more

0 comments, 107 reads

Posted in PowerSQL By Prashanth Jayaram on 14 October 2014

#TSQL2sday #59 – My Heroes

Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server. However, all of them have made a deep impact on my life. I am where I am today because of these nine.

1. James Tiberius Kirk

I start my… Read more

0 comments, 90 reads

Posted in Databases – Infrastructure – Security on 14 October 2014

Some Thoughts On Running a Chapter

Last week I spent some time after my presentation to Space Coast SQL talking to Kathleen Branch, the chapter leader, about what works and doesn’t work, and whether she was succeeding or not. We don’t seem to talk about that much publicly. When I was on the PASS Board we… Read more

7 comments, 109 reads

Posted in SQLAndy on 14 October 2014

T-SQL Tuesday #59–My Hero

It’s October, and another busy fall is underway for me. It’s also the second Tuesday, so it’s T-SQL Tuesday time again. The invite this month is from Tracy Mckibben, and it’s a neat topic. Not really a technical one, but a fun one that I like.

My Hero! is the… Read more

0 comments, 134 reads

Posted in The Voice of the DBA on 14 October 2014

TSQL Tuesday #59: My Hero, My Inspiration, My Wife

TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t) is hosting and wants us to talk about Heroes.

I have to admit this isn’t something I think about much. I have… Read more

0 comments, 124 reads

Posted in SQLStudies on 14 October 2014

Database Maintenance Plans: A Primer

Databases and newborns have a lot in common.  They both require constant care.  They both require constant monitoring.  They also may both puke on you in the middle of the night.  Unlike newborns, however, you can set up automated maintenance plans for databases.  If you’re starting a new gig as… Read more

0 comments, 4,926 reads

Posted in Adam Kreul | Blog on 14 October 2014

SQL Server Checksum

Use SQL Server Checksum in Data Warehousing


The post SQL Server Checksum appeared first on Derek Wilson - Blog.

Read more

0 comments, 175 reads

Posted in Business Intelligence and Enterprise Architecture on 14 October 2014

Database Mirroring States (SQL Server)

SQL Server Database Mirroring has 5 different states. According to BOL ( :-

Mirroring state Description
SYNCHRONIZING The contents of the mirror database are lagging behind the contents of the principal database. The principal server is sending log records to the mirror server, which is applying the changes…

Read more

0 comments, 141 reads

Posted in MSSQLFUN on 14 October 2014

T-SQL Tuesday #59: My Hero

This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).

Ada Lovelace has been an inspiration to many. In keeping with my blog theme, let’s call her a hero. We all have our heroes, those people who…

Read more

3 comments, 116 reads

Posted in Koen Verbeeck on 14 October 2014

Newer posts

Older posts