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

Latest Blog Posts

What is the Role of the UPDATE Lock in SQL Server?

The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The former is used to lock resources (e.g. rows, keys, tables) for read, and the latter is used to lock resources for write operations. The first is called SHARED, because multiple… Read more

0 comments, 98 reads

Posted in Guy Glantser on 18 November 2017

One More Trip and Down for the Count

The last month has been a rough one for me, with lots of travel. I was on trips for 4 out of the last 5 weeks, and the week I was home I had a remote presentation to do. Travel can be hard enough, but add in the need to… Read more

1 comments, 146 reads

Posted in The Voice of the DBA on 17 November 2017

New Session: Data Types Do Matter

I started speaking on a semi-regular basis this year after many years of trepidation.  You can read about my first speaking experience here.  It’s three years later and I have discovered that I love speaking.  I always wanted to be a teacher when I was younger, but it didn’t… Read more

0 comments, 82 reads

Posted in SQL Swimmer on 17 November 2017

Geek Sync Recording: Taking Control of Your SQL Server Sprawl

Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here:

Take Control of Your Organization’s SQL Server Sprawl

It’s about an hour long and it focuses on automation, setting up sized templates for servers, pushing and enforcing OS settings using… Read more

0 comments, 108 reads

Posted in Databases – Infrastructure – Security on 17 November 2017

Incorrect Syntax – What?

Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to throw the laptop out the window. What do we do though when the error message really does look to be pretty… Read more

0 comments, 87 reads

Posted in SQL RNNR on 17 November 2017

Training Day in London: Building Better SSIS Packages

I am delighted to announce that I’ll be delivering my full-day course, Building Better SSIS Packages, at the SQLBits conference in London on Thursday, February 22nd. This course is aimed at data professionals with experience in SQL Server and a general understanding of SQL Server Integration Services concepts. This will… Read more

0 comments, 90 reads

Posted in Tim Mitchell on 17 November 2017

SOS - Save Our Souls or SQL Operations Manager

On Wednesday Microsoft Announced the release in preview of SQL Operations Studio (SOS)... What is that I hear you cry! Well I asked myself the same question and did some digging.

SQL Operations Studio a client tool for working with SQL Server... It was announced at the PASS summit last…

Read more

0 comments, 106 reads

Posted in The SQL DBA in the UK on 17 November 2017

Friday Reading 2017-11-17

Fun week, lots of stuff to organise and prepare for! Whilst I’ve had some downtime I’ve been reading…

Write your first Pester test today
Rob (t) takes us through the steps to write a Pester test (something I’ve been meaning to do for ages)

How To Enlarge Your… Read more

0 comments, 100 reads

Posted in The DBA Who Came In From The Cold on 17 November 2017

Something cool we learned today!

We have many customers, and we work on lots of projects. Each project is different in so many ways: the business environment, the system architecture, the data platform, the people, the challenges…
This is why we get to learn so many new things on a daily basis, which is really… Read more

0 comments, 141 reads

Posted in Guy Glantser on 16 November 2017

Can I pause or resume an index rebuild operation?

One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database) is the option to pause and resume an online index rebuild operation.

This option can be useful for several use cases. Imagine you have a very large index, which takes… Read more

0 comments, 126 reads

Posted in Guy Glantser on 16 November 2017

How does Query Store capture cross database queries?

When I was writing my post  Capture the most expensive queries across your SQL Server using Query Store a question crossed my mind:

Query Store is a configuration that is enabled per database, and the plans and stats for queries executed in that database are stored in the database itself.… Read more

0 comments, 181 reads

Posted in Matthew McGiffen DBA on 16 November 2017

Azure SQL Database Alerting

It’s good to be proactive and one way is to setup alerts and it is no different when using Azure SQL Database. I like creating alerts for my Azure SQL Databases and I encourage you to do the same.

I keep things simple and like to look at certain performance… Read more

3 comments, 125 reads

Posted in All About SQL on 16 November 2017

Variables in Dynamic SQL

I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. I should point out here that I really enjoy dynamic SQL. I find it fairly intuitive and always enjoy the challenge, so I’ve gotten pretty good at it. So I… Read more

0 comments, 218 reads

Posted in SQLStudies on 16 November 2017

SQL Smackdown!!! Cursors VS Loops

Ladies and Gentlemen, welcome to the main event of the evening.  The SQL Undercover Smackdown Heavy Weight Championship of the World! 

In the red corner, we hate him, we loath him, I’ve even heard people say he should be deprecated, it’s the Cursor!!! 

Facing him in the blue corner, loved…

Read more

0 comments, 338 reads

Posted in SQL Undercover on 16 November 2017

Write Your first Pester Test Today

I was in Glasgow this Friday enjoying the fantastic hospitality of the Glasgow SQL User Group @SQLGlasgow and presenting sessions with Andre Kamman, William Durkin and Chrissy LeMaire

I presented “Green is Good Red is Bad – Turning your checklists into Pester Tests”. I had to make sure I… Read more

0 comments, 110 reads

Posted in SQL DBA With A Beard on 16 November 2017

You have your database in source control now what?

This post is for a specific type of person if you are:

  • New to source control
  • Are getting started on your path to the continuous delivery nirvana
  • Have been able to get your database into some sort of source control system
  • Have more than one person checking in code to…

Read more

0 comments, 104 reads

Posted in Ed Elliott's Sql Developer Blog on 16 November 2017

How To Enlarge Your Columns With No Downtime

Let’s face it: column enlargement is a very sensitive topic. I get thousands of emails every month on this particular topic, although most of them end up in my spam folder. Go figure…

The inconvenient truth is that enlarging a fixed size column is a long and painful operation, that… Read more

0 comments, 192 reads

Posted in SpaghettiDBA on 15 November 2017

Microsoft Connect(); announcements

Microsoft Connect(); is a developer event from Nov 15-17, where plenty of announcements are made.  Here is a summary of the data platform related announcements:

  • Azure Databricks: In preview, this is a fast, easy, and collaborative Apache Spark based analytics platform optimized for Azure. It delivers one-click set…

Read more

0 comments, 169 reads

Posted in James Serra's Blog on 15 November 2017

SQL Server 2017 Administration Inside Out

For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind, which is hopefully going to culminate in an actual technical book that I can point to and say “Yes, that’s the name I invented for… Read more

0 comments, 129 reads

Posted in Born SQL with Randolph West on 15 November 2017

PowerShell for fun (and profit?)

Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.

The post PowerShell for fun (and profit?) appeared first on The MidnightDBA Star-Times.

Read more

3 comments, 141 reads

Posted in SQL Awesomesauce on 15 November 2017

Older posts