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

Latest Blog Posts

SQL Server – DROP IF EXISTS in SQL Server 2016

Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets …

Continue reading Read more

0 comments, 21 reads

Posted in Kapil Blogs on 27 November 2015

Covering Indexes

Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a covering index. Before we look at those options, let’s talk about the need for a covering index.

The term covering index was created probably a decade ago. The idea is… Read more

0 comments, 26 reads

Posted in The Smiling DBA on 26 November 2015

Using Stored Procedures in SQL Server For Better Performance

Intoduction to Stored Procedures in SQL Server

SQL Server uses Different types of stored procedures. They are the quickest method of accessing and manipulating database on the server. SPs are codes and scripts that are predefined for repetitive tasks to be performed on the server involving a database/its table/pages,… Read more

0 comments, 59 reads

Posted in Zora's SQL Tips on 26 November 2015

Steps to create SQL database at Azure

Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into …

Continue reading Read more

0 comments, 77 reads

Posted in Kapil Blogs on 26 November 2015

Complete DAX Function Reference

The DAX function documentation in MSDN can be found on separate pages,  organized by function categories and then details for every function.  This is useful but you can’t view all of the functions in one searchable page.  If you don’t know exactly what you’re looking for, it can be a…

Read more

3 comments, 64 reads

Posted in SQL Server BI Blog on 26 November 2015

Know More About SQL Server Error number 6401


The ACID acronym standing for Atomicity, Consistency, Isolation and Durability is the foundation of SQL transactions. Transactions are used when the database has to be modified by using one or more SQL statements and to make sure the security of the database as well. However, at times, this normal… Read more

0 comments, 59 reads

Posted in Zora's SQL Tips on 25 November 2015

Convert select statements in scripts into Inline-TVF's automatically

In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror of horrors Scalar Functions. Taking select statements and turning them into in-line TVF's is actually really really simple using the TSql ScriptDom so here is another tool…

Read more

0 comments, 53 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

ScriptDomVisualizer - Now Displays TSqlParserToken's

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script.

Honestly if you are doing anything with the…

Read more

0 comments, 58 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

Issues and opinions on the PASS anti-harassment policy (#sqlpass)

PASS just published an anti-harassment policy reminder, quickly followed by a  blog by Wendy Pastrick (about a bad experience at last month’s conference, and why it took a while to report it). We’ve had some conversation on Twitter about it all, and a couple of jokes, and some back and…

Read more

2 comments, 91 reads

Posted in SQL Awesomesauce on 25 November 2015

Test if a File Exists with Powershell

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

Awhile back I wrote a PowerShell script (PoSh) to download the SQL Saturday XML files used for the Guidebook application. These contain a bunch of the information that… Read more

3 comments, 97 reads

Posted in The Voice of the DBA on 25 November 2015

Resolved: A Duty to Act

If you are a member of PASS, you probably got an email from our President, Thomas LaRock.  I interpreted his email as essentially a reminder that when attending PASS events we should all be professional and responsible for our actions.   The email was very well written and wasn’t pointed towards… Read more

5 comments, 67 reads

Posted in John Morehouse | on 25 November 2015

SSC Editorial: Early Adopters

I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as ‘early adopters’. There’s some truth to that, but not all MVP’s are early adopters and not all early adopters are MVP’s. What interested me more was the attitude, that… Read more

0 comments, 55 reads

Posted in SQLAndy on 25 November 2015

Women in technology

Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s a great read and I highly recommend it. In fact, go read it right now. I’ll wait.

You’re back? Good. So, her article got me… Read more

0 comments, 59 reads

Posted in SQLStudies on 25 November 2015

Changing case of T-SQL Keywords

Bert likes his T-SQL keywords in UPPERCASE, Ernie likes his in lowercase which causes some internal struggle as it is actually one person "Mr Bert Ernie" anyway I digress, whether you are working by yourself or in a team you sometimes want to change the case of all the keywords…

Read more

0 comments, 71 reads

Posted in Ed Elliott's Sql Developer Blog on 24 November 2015

SQL Server 2005 End of Support and Business Intelligence

How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other BI features? I was recently interviewed for a CIO Magazine article by freelance writer Andy Patrizio about what the end of support means for CIOs.  Thanks to the SQL Server…

Read more

0 comments, 87 reads

Posted in SQL Server BI Blog on 24 November 2015

We Are All Responsible

Today we all received an email from PASS's president Tom LaRock (blog/@SQLRockstar):

PASS Anti-Harassment Policy Reminder
It is unfortunate that I have to write this letter, but it has become necessary.
An Anti-Harassment Policy (AHP) was implemented in 2012 to help provide a harassment-free conference experience.…

Read more

0 comments, 73 reads

Posted in Nebraska SQL from @DBA_ANDY on 24 November 2015

Tuesday Morning SQL Break – November 24, 2015

It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and… Read more

0 comments, 87 reads

Posted in StrateSQL on 24 November 2015

Why Should Data Professionals Automate?

Take a minute and look around you. Automation is all around you; whether you see it or not processes are automated on all levels of life.

One thing that I’ve noticed among professionals is that “change” is very difficult; while others do not know what to automate.

Time and Value Read more

0 comments, 71 reads

Posted in The SQL Professor on 24 November 2015

Master Data Services Configuration Woes

Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re gonna get. Recently I ran into some troubles (or woes) when configuring MDS at a client. The installation went smoothly, as well as the installation of other prerequisites (like… Read more

0 comments, 71 reads

Posted in Koen Verbeeck on 24 November 2015

Quickly deploying procedure/functions from SSDT (Bypass Publish)

SSDT is great but one thing that is not so great is the performance of the publish. I am not complaining, I understand it does a lot and is well worth the wait when publishing however, when you are writing and testing code having this process really kills productivity:

  • 1.…

Read more

0 comments, 66 reads

Posted in Ed Elliott's Sql Developer Blog on 24 November 2015

Older posts