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

Latest Blog Posts

SQLCover v 0.2 - Bug fixes and Azure V12 Support

I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where you need to focus when writing tests).

This includes a few minor fixes but also support for SQL Azure so if you run your test in a v12 database or…

Read more

0 comments, 35 reads

Posted in Ed Elliott's Sql Developer Blog on 5 May 2016

Where do you put your business logic? In stored procedures?

There seems to be two trains of thought and I think this is mainly down to who and where your developers are. The first is that a stored procedure or a function is a great place to put all the business logic that an application needs. The second is that…

Read more

0 comments, 40 reads

Posted in Ed Elliott's Sql Developer Blog on 5 May 2016

Pensacola in June–SQL Saturday #491

One June 5, I’ll be back in Pensacola, FL for SQL Saturday #491. It’s been a few years since there was a conference in the area, and I’m excited to go back. I really like the area, and am looking forward to visiting for a few days.

I’ll be… Read more

1 comments, 98 reads

Posted in The Voice of the DBA on 5 May 2016

SQL Saturday Iowa City Precon – The Complete Primer to SQL Server Infrastructure

I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Iowa City on 6/10/2016 called ‘The Complete Primer to SQL Server Infrastructure‘.

The focus of the course is to help those new to the enterprise server infrastructure… Read more

0 comments, 39 reads

Posted in Technobabble by Klee from @kleegeek on 5 May 2016

SSIS Training Classes for Summer 2016

If you are looking for affordable, high-quality training on SQL Server Integration Services, you may be interested in one of the two full-day workshops I have scheduled for August of this year. I’ll be taking my popular course Building Better SSIS Packages on the road to Baton Rouge, Louisiana and… Read more

2 comments, 83 reads

Posted in Tim Mitchell on 5 May 2016

Another Day, Another City

After a few days in Copenhagen for SQL Nexus, I traveled to London late last night, and am now making my way to Liverpool for SQL Bits. A hectic schedule, leaving one city, flying to another, a few hours sleep and moving again today.

It’s exciting to be… Read more

0 comments, 70 reads

Posted in The Voice of the DBA on 5 May 2016

Free eBook – Azure SQL Databases


PuttingYour Head In the Cloud An Introduction to Cloud Computing and Azure SQLDatabases by David Postlethwaite has been revised in readiness for David’s session at SQL Bits this coming Saturday


 

Since the publication of the first edition of this book last year, the Azure portal has changed significantly and…

Read more

0 comments, 75 reads

Posted in The SQL DBA in the UK on 5 May 2016

SQL Server – Row Level Security in SQL 2016 – Part 2

Hi friends, in my previous post we have learnt how to implement Row Level Security feature in our database. You …

Continue reading Read more

0 comments, 144 reads

Posted in Kapil Blogs on 5 May 2016

Refocus

Three years ago, I left the ranks of full-time employment to become an independent consultant. At the same time, I partnered with Linchpin People, a guild of independent consultants made up of some of the very best practitioners in the database and business intelligence space. Working with Linchpin helped to… Read more

1 comments, 111 reads

Posted in Tim Mitchell on 4 May 2016

Word Wrap in SQL Server Management Studio

I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic question. It went something like this…

“Can you get the text in management studio to word-wrap?”

Word-wrap is not on by default. You can see from the image  below we… Read more

0 comments, 120 reads

Posted in The SQL DBA in the UK on 4 May 2016

New Azure storage account type

In Azure, there previously has been only one kind of storage account, which is now called a “General Purpose” storage account.  Just introduced is a new kind of storage account, called “Cool Blob Storage”.  When creating a storage account, the “Account kind” will now list two options: the existing type… Read more

0 comments, 93 reads

Posted in James Serra's Blog on 4 May 2016

Grant Deny Revoke

It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them.

TL;DR; GRANT and DENY are opposites. GRANT applies a positive permission, DENY a negative permission. DENY will always override GRANT. REVOKE is the opposite of GRANT and DENY. It removes… Read more

2 comments, 72 reads

Posted in SQLStudies on 4 May 2016

SSRS and MDX: Think about Cell Properties

I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about… Read more

0 comments, 88 reads

Posted in Koen Verbeeck on 4 May 2016

Word-wrap in SQL Server Management Studio

I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic question. It went something like this…

“Can you get the text in management studio to word-wrap?”


Word-wrap is not on by default. You can see from the image  below…

Read more

0 comments, 81 reads

Posted in The SQL DBA in the UK on 4 May 2016

How do you audit automatically generated sql deployment scripts?

I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements for auditing and the ability to be able to demonstrate exactly what was deployed at what time.

When automating deployments it…

Read more

0 comments, 168 reads

Posted in Ed Elliott's Sql Developer Blog on 3 May 2016

Implicit Conversion and Performance

Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run on each column, you can’t get an index seek. Instead, you’re forced to use a scan. I can demonstrate this pretty simply. Here’s a script that sets up… Read more

1 comments, 101 reads

Posted in The Scary DBA on 3 May 2016

Weekly Round-up 30 April 2016


It’s been an interesting week for me. I spent last week in Toronto delivering a SQL Server upgrade course and a very enjoyable week it was too.  Couldn’t get tickets for the Raptors playoff game so I have to make do watching it on TV and treat myself to…

Read more

0 comments, 104 reads

Posted in The SQL DBA in the UK on 3 May 2016

SQL Server Error 3013: Restore Database is Terminating Abnormally

Overview of SQL Server Error 3013

One of the most frustrating situations that a user experiences while working with SQL Server is when errors are encountered. These errors disrupt the normal functioning of SQL Server and in worst case scenario may even lead to data loss. Sometimes, SQL Server Backup… Read more

0 comments, 140 reads

Posted in Zora's SQL Tips on 3 May 2016

SQL Server – Row Level security in SQL Server 2016 – Part 1

Hi friends, in SQL 2016 several new security features gets introduced which will help users to protect their data in …

Continue reading Read more

1 comments, 139 reads

Posted in Kapil Blogs on 3 May 2016

Goodness-of-Fit Testing with SQL Server Part 7.3: The Anderson-Darling Test

By Steve Bolton

…………As mentioned in previous installments of this series of amateur self-tutorials, goodness-of-fit tests can be differentiated in many ways, including by the data and content types of the inputs and the mathematical properties, data types and cardinality of the outputs, not to mention the performance impact… Read more

0 comments, 85 reads

Posted in Multidimensional Mayhem on 2 May 2016

Older posts