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

Latest Blog Posts

Webinar: Auditing with Extended Events

I’m giving a webinar today, April 5th, at 3 PM Eastern, on using Extended Events to audit your SQL Servers. I’ll be covering the basics of why you should migrate from Profiler to Extended Events, what Extended Events are and how they are structured, as well as some initial use… Read more

0 comments, 139 reads

Posted in Databases – Infrastructure – Security on 5 April 2018

Ohhhhhh S…t!! A tribute to Robert Davis

Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community.
I was introduced to Robert many years ago at one of the PASS Summits. I had known of him as a SQL genius well before that. One of my good friends… Read more

1 comments, 2,725 reads

Posted in Mala's Data Blog on 5 April 2018

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:


{
"comments": "Managed Disk.",
"type": "Microsoft.Compute/disks",
"name": "[variables('diskName')]",
"apiVersion": "2016-04-30-preview",
"location": "[parameters('location')]",
"tags": {
"displayName": "Data Disk 1 - Presented as LUN 0"
},
"properties": {
"accountType": "Premium_LRS",
"creationData": {
"createOption":…

Read more

0 comments, 133 reads

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

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like: { "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location": "[parameters('location')]", "tags": { "displayName": "Data Disk 1 - Presented as LUN 0" }, "properties": { "accountType": "Premium_LRS", "creationData": { "createOption":…

Read more

0 comments, 59 reads

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

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like: { "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location": "[parameters('location')]", "tags": { "displayName": "Data Disk 1 - Presented as LUN 0" }, "properties": { "accountType": "Premium_LRS", "creationData": { "createOption":…

Read more

0 comments, 9 reads

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

What is a Foreign Key & How many foreign keys can you have on a single table?

Yesterday, I was attending a database design meeting. In the meeting, I was asked one of the questions – “How many foreign keys can you have on a single table?” Honestly, I had no clue about the limit. But, I must acknowledge that it was an excellent question… Read more

2 comments, 2,553 reads

Posted in SQL Geek on 5 April 2018

Extending built-in data types

add generic user defined table data types as extension to built-in ones

Read more

1 comments, 13 reads

Posted in SQL Design Patterns on 5 April 2018

Farewell, Robert Davis

Robert Davis (@SQLSoldier) died on Monday. A great technical guy, he did a lot of writing and presenting and answering questions over the years, shared a lot of knowledge and hard won lessons about working with SQL.  For years to come people will be trying to find an answer and… Read more

2 comments, 2,545 reads

Posted in SQLAndy on 4 April 2018

Why didnt my Azure ARM deploy work?

I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn’t have any debugging information enabled and when you run this powershell: New-AzureRMResourceGroupDeployment If you don’t have debugging information enabled, the output of a failed deployment is…

Read more

0 comments, 12 reads

Posted in Ed Elliott's Sql Developer Blog on 4 April 2018

Why didnt my Azure ARM deploy work?

I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn’t have any debugging information enabled and when you run this powershell: New-AzureRMResourceGroupDeployment If you don’t have debugging information enabled, the output of a failed deployment is…

Read more

0 comments, 19 reads

Posted in Ed Elliott's Sql Developer Blog on 4 April 2018

Why didn't my Azure ARM deploy work?

I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn't have any debugging information enabled and when you run this powershell:

New-AzureRMResourceGroupDeployment

If you don't have debugging information enabled, the output of a failed deployment is…

Read more

0 comments, 1,409 reads

Posted in Ed Elliott's Sql Developer Blog on 4 April 2018

Encrypting SQL Server Database Backups

We all go to great lengths to make sure that our databases are secure (or at least I really hope that we do), we make sure that only authorised users have access and then only to the databases and levels that they need.  We’re careful that all our passwords conform… Read more

2 comments, 1,897 reads

Posted in SQL Undercover on 4 April 2018

Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018

I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two sessions: Back to the Future with Temporal Tables What’s New In SQL Server 2017 SQLSaturday is a volunteer-based day of free training for data professionals, and I encourage you to… Read more

0 comments, 144 reads

Posted in Born SQL with Randolph West on 4 April 2018

Toolbox - Do You Have Current Backups?

On our managed servers we run a job each day to check that either a FULL or DIFF has run in the last 24 hours, but all-too-frequently I find myself on a server that we don't manage, trying to determine the current situation (aka the "health check").

An important thing…

Read more

0 comments, 186 reads

Posted in Nebraska SQL from @DBA_ANDY on 4 April 2018

Default and Custom Widgets in SQL Server Operations Studio

There are already a number of articles and blog posts that reveal the benefits of the SQL Operations Studio tool. The demand created across the software and the related tools are relatively unimaginable than ever before. The trend and growth will continue to increase in the upcoming days.

The graphical… Read more

0 comments, 1,692 reads

Posted in PowerSQL By Prashanth Jayaram on 4 April 2018

I Am Speaking At Music City Tech

I am excited to announce that I have been selected to speak at Music City Tech held at Vanderbilt University in Nashville, TN, May 31 – June 2 2018.  Music City Tech is a multiday event with three simultaneous conferences, Music City Code, Music City Agile and Music City… Read more

0 comments, 113 reads

Posted in SQL Swimmer on 4 April 2018

Use Boot Diagnostics to see what your Azure VM is doing at boot time

This blog post is about how to diagnose what your Azure VM is doing while it is booting.

I have a DEMO VM that is hosted in Azure – it is where I have Visual Studio, Redgate tools as well as all my DEMO systems, presentations hosted for when I… Read more

0 comments, 1,247 reads

Posted in The Hybrid DBA's Blog on 4 April 2018

Power BI Monthly Digest – April 2018

Welcome to a new series that Manuel Quintana [Blog | Twitter] and I are starting where we will cover some of the top Power BI features released each month. In our April 2018 edition you will learn about:

  • New DAX function: COMBINEVALUES()
  • Generally available release of Organizational Visuals

Read more

0 comments, 185 reads

Posted in Devin Knight on 4 April 2018

SSMS’s Dark Theme

There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the answers really are yes, and no. And by that I don’t mean yes and no as in maybe. I mean litterally, does it exist yes and will it exist… Read more

3 comments, 172 reads

Posted in SQLStudies on 4 April 2018

7 Steps to Repair Database from Corruption

SQL Server Database is an advance relational database management system, which is widely used by business professionals. But one of the serious issue one faces is SQL Server Database Corruption.

It is estimated that 99% of Database Corruption in SQL Server is caused due to the problem in IO subsystem… Read more

0 comments, 231 reads

Posted in SQL Server Overview on 4 April 2018

Newer posts

Older posts