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

Latest Blog Posts

Using Snippets

A while ago I talked about Templates. This is an easy way to get a, well, template of a piece of code. But a much faster way to get a simple template is to use a snippet. With a simple key command (ctrl-K, ctrl-X) you can… Read more

0 comments, 91 reads

Posted in SQLStudies on 17 October 2016

Read this before using SQL 2016 Temporal Tables

I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of our production databases. It’s a neat feature that honestly adds a boat load of possibility around logging.

In my testing I noticed that user created tables seem to store the… Read more

0 comments, 1,885 reads

Posted in Confessions of a Microsoft Addict on 17 October 2016

Query Plan's Compile Time Parameter Values

Most of you would know how to get the query plan from the cache via "sys.dm_exec_cached_plans" or "sys.dm_exec_query_stats" DMV or via a "sys.dm_exec_requests" with the plan_handle. But one interesting thing which many not have noticed is the ability to check the "compile time" parameter…

Read more

0 comments, 80 reads

Posted in SQL and SQL Only on 17 October 2016

The dark side of Fn_dump_dblog

I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are consistently dumping the contents into a table for analysis) The below 2 queries shows the current state of my system … Continue reading

Read more

2 comments, 904 reads

Posted in All About SQL on 17 October 2016

Centralized Management Server 101

Registered Servers

I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. :-) This is definitely not the intended usage. As I've explored the benefits of using this a little more, I put a few notes together to help share the concepts I came across.… Read more

0 comments, 1,281 reads

Posted in SQL Barbarian on 16 October 2016

Do you know Compress & Decompress function in SQL SERVER 2016 ?

This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware of Gzip Compression algorithm. If not then try  this link.

So, SQL SERVER 2016 introduce this two awesome functions for Compress & Decompress the data.

Read more

2 comments, 133 reads

Posted in Rajat Jaiswal-337252 on 16 October 2016

Here Come New Ideas for DROP IF EXISTS in SQL SERVER

In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a new cool feature which introduced in SQL SERVER 2016 which is DROP IF EXISTS (DIE) .
In our development many times it happens that we need to drop a…

Read more

0 comments, 141 reads

Posted in Rajat Jaiswal-337252 on 15 October 2016

Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014

A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of the new level 1200 compatibility model. But they weren’t yet ready to upgrade their SSIS server from SQL 2014. This presented a problem because they had been using the Analysis… Read more

2 comments, 540 reads

Posted in Data Savvy on 14 October 2016

Thursday Night Networking Dinner Meetup at Summit 2016

This year PASS announced that Thursday night would be an open night at the PASS Summit, with no events scheduled. Typically Microsoft has sponsored a party at Gameworks, but not this year. PASS has a list of events at the Summit, if you want to browse. Many of these… Read more

4 comments, 605 reads

Posted in The Voice of the DBA on 14 October 2016

Mastering Index – Unique Index

This article is the part of series Mastering Index, in this particular article we will be exploring Unique Index. Take a look at the content of this series -  Mastering Index  One of the most interesting and talked about topic in database field is Index. I am writing this Series…

Read more

0 comments, 219 reads

Posted in Help on MSBI on 14 October 2016

What’s new in SSRS 2016 – Session Contents

The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was very nice meeting up with the #sqlfamily again. I had a session about the new features in SSRS 2016. I was so excited that I could do a… Read more

0 comments, 145 reads

Posted in Koen Verbeeck on 14 October 2016

Control Flow Package Parts in SSIS 2016

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server Integration Services packages.  The intent is great, but like with many first iterations, there are limited use cases, and rough edges.  I'll provide an overview of those here, and in…

Read more

4 comments, 1,223 reads

Posted in Todd McDermid's Blog on 14 October 2016

Learn Uses of log_reuse_wait_desc In SQL Server


Many times, while working on SQL Server, the transaction log files frequently grow due to various reasons. Out of which, one such reason is that there is, already existing assigned space of the file in the SQL Server. This can be happened due to increment in the utilization of… Read more

0 comments, 182 reads

Posted in Zora's SQL Tips on 13 October 2016

Why I Practice Presentations

I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want to be well prepared and ready for the events. It’s the least I can do for people who have spent money to attend an event.

I enjoy IT/DevConnections, and… Read more

2 comments, 342 reads

Posted in The Voice of the DBA on 13 October 2016

Too many indexes!

Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.

Different indexes work best for different queries. In a system with a lot of queries that means we could need a lot of indexes. Fortunately we can have up to 999 non-clustered indexes… Read more

0 comments, 145 reads

Posted in SQLStudies on 13 October 2016

My thoughts on Recertifying your MCSE through Microsoft Virtual Academy

A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in my blog post How I prepared myself for the MCSE certification. As you might know, this certification is only valid for 3 years. My certification should… Read more

12 comments, 241 reads

Posted in Koen Verbeeck on 13 October 2016

You don't need any Training? OK...I believe you.

This week's Super duper IT training offers are in:

If you see any that take your fancy let me know. Drop an email etc. 

Running in London or if you prefer you can attend online. Courses are running this November and December. 

Get in early when they are full, they…

Read more

0 comments, 116 reads

Posted in The SQL DBA in the UK on 13 October 2016

Microsoft Certifications

Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place regarding certification within the Data Platform space. (Check out the link – Nothing has changed in terms of … Continue reading

Read more

1 comments, 224 reads

Posted in All About SQL on 13 October 2016

A quick note comparing ISNULL vs COALESCE

There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also plenty of arguments of why you should use one over the other.

I’m in the ISNULL camp. I once argued about this with a Microsoft MVP. He was adamant that… Read more

0 comments, 189 reads

Posted in Confessions of a Microsoft Addict on 13 October 2016

MS Access – Store a Different Value than Displayed in a Combo Box

It is occasionally usefully to display a different values in an Access combo box than what is actually stored in the table.  This can be done if you want to store the primary key in another table to make a … Continue reading

Read more

0 comments, 173 reads

Posted in SQLWise on 13 October 2016

Newer posts

Older posts