SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Table Internal Sync Rule–Substituting the Sync Column

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it works, but I do find it a little challenging sometimes to figure out how to mask values. I’ve written a set of posts for different scenarios.

In a previous post Read more

0 comments, 185 reads

Posted in The Voice of the DBA on 6 March 2018

Book Review: SQL Server 2017 Machine Learning Services With R

Disclaimer: I’m one of the Technical Reviewers for this book.

With the rising demand for cloud computing and wide adaptation of cloud-based analytics platforms such as Data Lake Analytics and the likes, the chasm between the traditional Data Professionals and their need for analytics literacy is becoming wider and wider.… Read more

0 comments, 571 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 6 March 2018

Identify the owner and then change the owner of a SQL Agent Job

In this post and video you will learn how to identify the owner and then change the owner of a SQL Agent Job.

Have you ever had issues where the owner of a SQL Agent job leaves and their windows active directory account gets deleted/removed/disabled and the job(s) they own…

Read more

1 comments, 1,834 reads

Posted in The SQL DBA in the UK on 6 March 2018

Classifying your data in Azure SQL DB for GDPR

Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio (SSMS); though, the management tasks available from SSMS for Azure SQL DB may not exist, such as: data classification.

You may have read my last post How to classify your… Read more

0 comments, 117 reads

Posted in Confessions of a Microsoft Addict on 6 March 2018

2.5 Ways Your ORM Is Vulnerable To SQL Injection

Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.

Oh boy.

ORMs don’t automatically prevent SQL injection

Object-relational mapping (ORM) tools allow developers to easily access an application’s data layer without having to write lots of redundant code.


Most… Read more

0 comments, 1,982 reads

Posted in Bert Wagner on 6 March 2018

Profiler for Extended Events: Quick Settings

Not long ago, I wrote a rather long article about a new-ish feature within SQL Server Management Studio (SSMS) that impacted Extended Events. You can read that book – here! The XEvents Profiler feature is one of those things that you may or may not use. If you consider… Read more

0 comments, 1,470 reads

Posted in SQL RNNR on 5 March 2018

VSTS extensions, mixing VSS.require and import ... require

I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing a few vsts extensions and using typescript to write vsts extensions seems to be working quite nicely. One of the best things, for me, about typescript is to use type…

Read more

0 comments, 112 reads

Posted in Ed Elliott's Sql Developer Blog on 5 March 2018

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However, we always seem to find ourselves needing to allow someone to execute something that requires one or two higher-level permissions. Yet, in order to allow for just one extra… Read more

1 comments, 1,678 reads

Posted in SQL Quantum Leap on 5 March 2018

How to classify your data for GDPR

The right to be forgotten. It’s a concept that sounds great for people who are concerned about their personal information (PII) but it’s a complex issue for developers and data professionals.

GDPR is the European law that is intended to empower individuals with the ability to control the surface area… Read more

0 comments, 165 reads

Posted in Confessions of a Microsoft Addict on 5 March 2018

SSMS 17.4 Vulnerability Assessment

SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4

It seems that the Microsoft tools team is trying to build us better tools that come with the platform. There are good third parties that build tools, such as my employer,… Read more

0 comments, 1,979 reads

Posted in The Voice of the DBA on 5 March 2018

It’s all about the use cases

There is no better way to see the art of the possible with the cloud than in use cases/customer stories and sample solutions/architectures.  Many of these are domain-specific which resonates best with the business decision makers:

Use cases/customer stories

Microsoft IoT customer stories: Explore Internet of Things (IoT) examples… Read more

1 comments, 128 reads

Posted in James Serra's Blog on 5 March 2018

Every Single Execution Plan is an Estimated Plan

All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.

Where Do You Get Execution Plans?

There are a lot of sources for execution plans. You can capture them using extended events (or, if you must, trace). You can capture… Read more

4 comments, 1,514 reads

Posted in The Scary DBA on 5 March 2018

SQL Homework – March 2018 – Recovery Objectives

My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases (there might be some reporting people who are exceptions) need to know how to take a backup. If nothing else you need to know how to save your work.… Read more

0 comments, 120 reads

Posted in SQLStudies on 5 March 2018

Error 33206 - SQL Server Audit Failed to Create the Audit File

One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?


Exhibit A - the 33206:
Error: 33206, Severity: 17, State: 1.
SQL Server Audit failed to create the audit file 'T:\MSSQL\Audit Files\PLAND_Objects_DML_Audit_Events_A2B00B57-4B43-4570-93C8-B30EE77CC8C9_0_131645629182310000.sqlaudit'. Make sure that the disk is not full and that…

Read more

0 comments, 1,258 reads

Posted in Nebraska SQL from @DBA_ANDY on 5 March 2018

Four Ways to Find Free Space In SQL Server Database

Determine Free Space In SQL Server Database

In our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using them in SQL Server. Now, In this article we will discuss about how to check free space in SQL Server…

Read more

0 comments, 118 reads

Posted in SQL Server Overview on 5 March 2018

The Hidden Price Of Foreign Keys

Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another table have an actual correspondence in the referenced table – in other words, that the key value actually exists. They guard against orphaned records by not allowing the referenced record… Read more

2 comments, 169 reads

Posted in The Monday Morning DBA on 5 March 2018

Calculating DTU's for Azure SQL Database

One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL Server licensing. Azure SQL Database pricing depends on the database service tier options ,such as Database Transaction units and the maximum…

Read more

0 comments, 243 reads

Posted in Ganapathi's MSSQLLover on 5 March 2018

Configure Read only routing for an always on availability group

One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary SQL Server replicas in always on availability group. Read-only routing refers to the ability of SQL Server to route qualifying read-only connection requests to an available Always On readable secondary replica

Read more

0 comments, 112 reads

Posted in Ganapathi's MSSQLLover on 5 March 2018

SQL Saturday 723, March 24, 2018 in Rochester, NY. Join us and kick your SQL Server knowledge up a notch!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

This year I’m excited to give 2… Read more

0 comments, 133 reads

Posted in cjsommer.com on 2 March 2018

Using the Analysis Services Execute DDL Task

My grandfather used to say, “There’s more than one way to skin a cat.”  I always thought it was a disgusting saying, I mean who would ever want to “skin a cat”?!  Gross!  But the underlying meaning was clear, there’s always more than one way to do something.  And no… Read more

3 comments, 1,554 reads

Posted in SQL Swimmer on 2 March 2018

Newer posts

Older posts