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

Latest Blog Posts

SQL Server: DBCC CHECKDB Command with Complete Explanation

SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to different reasons. Therefore, to deal with this issue SQL Server has a command, which act as a manual solution for corruption of the database. This command is referred as DBCC…

Read more

0 comments, 270 reads

Posted in SQL Mighty on 17 March 2017

PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.

But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session… Read more

0 comments, 99 reads

Posted in The Smiling DBA on 17 March 2017

Friday Reading 2017-03-17

As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready for SQL Saturday Iceland tomorrow! Been looking forward to this for a while now, my first opportunity to give a full session on a subject that I’ve become quite involved… Read more

0 comments, 91 reads

Posted in The DBA Who Came In From The Cold on 17 March 2017

Global v Session Trace Flags

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here.

In the article, I set trace flag 3226 for my session. This showed… Read more

0 comments, 177 reads

Posted in The Voice of the DBA on 16 March 2017

Check Those Settings

Recently, I was tasked with “enhancing” a third party application.  This third party application (TPA) outputs a bunch of files to a file share in a way that makes sense to the application, but makes no sense to a human. 

The Task

Make a copy of these files in a… Read more

1 comments, 176 reads

Posted in SQL Swimmer on 16 March 2017

Compressed backup errors and TF 3042

Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time saved by reduced IO) and of course, the backups are smaller. I have run into a few issues, however.

On one occasion there was 75gb free on a drive, the… Read more

4 comments, 110 reads

Posted in SQLStudies on 16 March 2017

Return to Birmingham for SQLSaturday Bham 2017!

It's been 2.5 years since I last spoke at SQLSaturday Birmingham, and I'm eager to make a return, this time with two more Sparkhound colleagues in tow and an amazing secret raffle prize to giveaway at the end!

We'll see you there on Saturday!

Sparkhound speakers in the lineup

Read more

0 comments, 72 reads

Posted in SQL Tact on 16 March 2017

An Introduction to Containers and Docker

By Chris Gibson

This is the debut blog post  of  Chris Gibson. Chris is in expert in Microsoft  Windows and is turning his attention more and more to the Cloud. You can read more about Chris on the About Us Page


This introduction to Containers and Dockers…

Read more

0 comments, 682 reads

Posted in The SQL DBA in the UK on 16 March 2017

Create a BACPAC–#SQLNewBlogger

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

One of the things that you might encounter at some point is the need to create a BACPAC. This is essentially a DACPAC with data included. There… Read more

0 comments, 158 reads

Posted in The Voice of the DBA on 15 March 2017

The Livestream Product Launch

SQL in the City Streamed in 2016 was a success, with lots of feedback that people enjoyed the sessions and format. With the release of SQL Clone, we’ve decided to do it again.

The SQL Clone Product Launch Live Stream is coming in a couple weeks, on Mar 29,… Read more

0 comments, 191 reads

Posted in The Voice of the DBA on 15 March 2017

Webinar – Datacenter Madness – Application Altercation

I hope you all can join me for an upcoming webinar as part of the Datacenter Madness webinar series, presented by ActualTech Media, Nutanix, and Intel. The Madness is moving from the basketball court to the cloud. It’s time for the ultimate data center showdown where… Read more

0 comments, 108 reads

Posted in Technobabble by Klee from @kleegeek on 15 March 2017

Corrupt Database – I need that data now!

My database is in the recovery pending state and I want to get in and extract the data out into a new database, I have NO BACKUPS available so some data (even if it is dodgy) is better than nothing. … Continue reading

Read more

3 comments, 142 reads

Posted in All About SQL on 15 March 2017

Summary of my Container Series

I’ve written a few articles on containers so I thought it’d be a good idea to have a page that listed them for easy reference. So here’s all the posts: –

Running your first container

Building a custom image

Pushing images to the Docker Hub

Using WinDocks to run earlier… Read more

1 comments, 121 reads

Posted in The DBA Who Came In From The Cold on 15 March 2017

T-SQL Tuesday #88 – WTF

It’s T-SQL Tuesday time again, and this is a good one. The host this month is Kennie Pontoppidan, who I had the pleasure of running with one morning in Copenhagen. His theme is The daily (database-related) WTF.

You can read about T-SQL Tuesday at tsqltuesday.com and see all… Read more

0 comments, 301 reads

Posted in The Voice of the DBA on 14 March 2017

T-SQL Tuesday #88 – The daily (database-related) WTF

It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and the topic is “daily database related WTF”. In other words, we get to tell one of our horror stories we encountered in our career as… Read more

0 comments, 180 reads

Posted in Koen Verbeeck on 14 March 2017

Limits vs Goals

It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us.

The daily (database-related) WTF

Database horror stories. Things that make your eyes pop and not in a good way. What a fun topic! But not an… Read more

0 comments, 586 reads

Posted in SQLStudies on 14 March 2017

T-SQL Tuesday #88: My Top WTF Moments

Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily (database-related) WTF”, and I want to share some of my top WTF moments. If you would like to participate in this month’s blog party, go to Kennie’s invitational blog post:…

Read more

Power BI Custom Visuals Class (Module 42 – Stars)

In this module you will learn how to use the Stars Power BI Custom Visual.  The Stars visual is a great way to visualize ratings data.

Module 42 – Stars


Key Takeaways

Read more

0 comments, 195 reads

Posted in Devin Knight on 14 March 2017

Insufficient Disk Space (T-SQL Tuesday #88)

This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be inspired by the IT horror stories from http://thedailywtf.com, and tell our own daily WTF story.

Years ago in a previous job, I… Read more

2 comments, 1,457 reads

Posted in Data Savvy on 14 March 2017

Is Your Data Open to Abuse? T-SQL Tuesday

T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. This month’s host is Kennie Nybo Pontoppidan (b|t) and this months topic is: The daily (database-related) WTF.

Some of the biggest WTF moments… Read more

1 comments, 947 reads

Posted in The Database Avenger on 14 March 2017

Newer posts

Older posts