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

Latest Blog Posts

Whoisactive capturing a SQL server queries Performance Tuning


Whoisactive stored procedure is a powerful script to capture the SQL server queries with tons of information. It’s written by Adam Machanic. It makes DBAs job easier.

It’s a great script with lots of parameter and I am going to show, which are all more important.

Run the stored… Read more

5 comments, 1,798 reads

Posted in SQL Server Blog Forum on 18 July 2016

Limitation of In-Memory OLTP in SQL 2016 – Create Index is not supported

Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you create a table you cannot create any index created on memory optimized table using CREATE INDEX statement. So to create indexes you need to create them with column definition of…

Read more

1 comments, 178 reads

Posted in Kapil Blogs on 17 July 2016

Karla Set the Standard

Last week Karla Landrum announced that she will be leaving her position as Community Evangelist later this year after five years. That means change for PASS and for us and for Karla, but just the nature and scale of that pending change illustrates how much Karla has done in the… Read more

0 comments, 1,042 reads

Posted in SQLAndy on 17 July 2016

SQLSaturday Baton Rouge 2016!

Free SQL Server, SharePoint and .NET training

SQLSaturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQLSaturday event is sponsored by the Baton Rouge SQL Server and .NET User Groups, and will be our…

Read more

0 comments, 138 reads

Posted in SQL Tact on 16 July 2016

MeasureUp 2016

I’m heading down to Austin next weekend for MeasureUp 2016. This is a Microsoft stack conference that looks to help people build custom business software.  There are over 20 sessions, most of them devoted to .NET topics. I think I’m more excited to be in some nice company and… Read more

0 comments, 207 reads

Posted in The Voice of the DBA on 16 July 2016

Speaking at SQLSaturday Sacramento!

I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 23th 2016! This will be my third SQLSaturday event this year and I’m really excited that I get to do it as a speaker. I look forward to seeing you there! 

If you don’t know… Read more

0 comments, 158 reads

Posted in Anthony Nocentino's Blog on 15 July 2016

Azure SQL Database waits you should be aware of…

I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and thought I’d take a moment to highlight the interesting behavior you may run into as well.

As you can expect with any type of SQL Server solution, the normal wait… Read more

0 comments, 301 reads

Posted in Confessions of a Microsoft Addict on 15 July 2016


Despite the traditional relational DB world, a new trend is emerging which is called NoSQL. Its really hard to define NoSQL. You will get lot of information, opinions on what NoSQL is all about. This is just my understanding and research on NoSQL.

Its all about

  • Non-relational,
  • Open source,
  • Cluster…

Read more

0 comments, 290 reads

Posted in PowerSQL By Prashanth Jayaram on 15 July 2016

GIT Learning Resources

I’ve spent most of my career using VSS and TFS, mainly because that’s what was being used. Better any source control than none. Now I’m working with a tam that uses Git, so I’m learning enough to check-in changes and merge and clean and the other basics. I’ve gathered… Read more

2 comments, 152 reads

Posted in SQLAndy on 15 July 2016

TGI Friday (Live Blog Day 4)

Its been long but productive week at Tree Tech

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks success live blogging from the back of the room whilst producing the 294 influence skills course, this week I’m…

Read more

0 comments, 151 reads

Posted in The SQL DBA in the UK on 15 July 2016

SQLServerZest is now DataGinger!

We are happy to announce the birth of DataGinger. Starting today we officially re-branded ourselves as (previously The main motive for this change is to expand our blogging topics beyond SQL Server and widen our scope to include all data related technologies. -Your Friends at DataGinger

Read more

0 comments, 96 reads

Posted in - SQL in simple style on 15 July 2016

Introduction to Power BI Desktop – Recording Now Available

Thank you to everyone that attended this past Tuesday’s webinar hosted by Pragmatic Works called Introduction to Power BI Desktop. We had a great turn out! If you missed the webinar, you can view the recording here.

Check out these five Power BI tips!

There were lots of great… Read more

3 comments, 169 reads

Posted in SQL with Dustin Ryan on 15 July 2016

SQL Server CTE – Back to Basics

Quick Flashback

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

2 comments, 1,930 reads

Posted in SQL RNNR on 14 July 2016

SQL Server Indexing Book Giveaway – Week 6 (Index Myths)

And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway.  So far, I’ve sent out five copies of the book based on comments from these (1, 2, 3, 4, and 5) posts.

Expert Performance… Read more

5 comments, 180 reads

Posted in StrateSQL on 14 July 2016

Getting Table Change Scripts–#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 really basic things I think everyone should understand is how to get scripts from Management Studio (SSMS) and saving them. In fact, I’ve written… Read more

0 comments, 247 reads

Posted in The Voice of the DBA on 14 July 2016

Altering a column in a large table: A case study

Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to share each of them and the results of those I tried. I will not be giving any specific examples or code. Feel free to give me your opinion in the… Read more

5 comments, 391 reads

Posted in SQLStudies on 14 July 2016

Get Your Email Out of my ETL

Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My response: “I don’t.” The tl;dr version of this post is I let my extract-transform-load processes do just ETL, and leave notifications to the scheduling system where they belong. Get Your… Read more

0 comments, 305 reads

Posted in Tim Mitchell on 14 July 2016

Live From @LearningTree London Backup and Restore - Day 3

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks success live blogging from the back of the room whilst producing the 294 influence skills course, this week I’m in the process of trying this from the front…

Read more

0 comments, 168 reads

Posted in The SQL DBA in the UK on 14 July 2016

SQL Server Desired Enhancements

Happy Belated Birthday

The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month – or at least is supposed to happen on that day. This month, the formidable Chris Yates (blog | twitter) has invited everybody to a birthday party Read more

4 comments, 166 reads

Posted in SQL RNNR on 13 July 2016

Source Control for the Reluctant DBA

This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I encountered at work and how they provided the inspiration for using source control in my SQL Server projects. This post will focus on using the version control system… Read more

1 comments, 302 reads

Posted in The Database Avenger on 13 July 2016

Newer posts

Older posts