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

Archives: December 2016

Survey Results: Skipping the Holidays

Last week I posted a brief survey about working the holiday. To those who normally are not required to work the holidays, I asked if they would be willing to do so if the price was right, and if so, what that price would be (relative to what they normally… Read more

0 comments, 278 reads

Posted in Tim Mitchell on 27 December 2016

Query Data Store–SQL Server 2016

SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to do performance tuning on T-SQL queries. This new feature of SQL Server 2016 is contained within a database with configuration options for storage of history and query plans. The option… Read more

0 comments, 341 reads

Posted in The Smiling DBA on 27 December 2016

New Formatting in #SQLPrompt

I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t be any better, a new formatting engine has been released.

Reading through existing source code and understanding the intent is an important part of any software developer’s life. Often,… Read more

1 comments, 397 reads

Posted in The Voice of the DBA on 27 December 2016

A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup

I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery and I was pleased to see this line of my invitation quoted several times.

Backups are one of the most common things DBAs discuss, and they are at once one…

Read more

0 comments, 287 reads

Posted in SQLStudies on 26 December 2016

Query Store- Part 5: Checking forced plans and Query Store Failures

Most of you would know that using query store one can force query plans. Is there a need to check what plans are forced? Why?

Fundamentally, two important reasons for checking forced plans. 

1) To check if the query is yielding the desired performance?. The performance needs to be obviously…

Read more

1 comments, 334 reads

Posted in SQL and SQL Only on 26 December 2016

Configure Internal and Private Networking for Hyper-V Virtual Machines

In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine. Now, we will explore how to create Internal and Private virtual switches and what is the use of them. A virtual switch is also bound to the host server even… Read more

1 comments, 184 reads

Posted in SQL Geek on 25 December 2016

User Contains Invalid Characters – Back to Basics

Remember When…

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

0 comments, 469 reads

Posted in SQL RNNR on 24 December 2016

Indexes optimize for the system databases

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments.

It’s also important to know that the indexes in msdb and master are marked as system objects, so if you have… Read more

0 comments, 57 reads

Posted in Si vis pacem, para sql on 23 December 2016

Survey: Skipping the Holidays?

For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your response. Your holiday plans are made. All of your family and friends expect to see you at the annual holiday gathering. Your kids are expecting you there on Christmas morning… Read more

3 comments, 247 reads

Posted in Tim Mitchell on 23 December 2016

Column and table constraints

Column and Table Constraints

Constraints can be column constraints or table constraints.
A column constraint is specified as part of a column definition and applies only to that column.

A table constraint is declared independently from a column definition and can apply to more than one column in a table.…

Read more

0 comments, 116 reads

Posted in TSQL Circle Live on 23 December 2016

What is Constraints in TSQL?

Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity.Constraints is preferred to using DML Triggers, rules, and defaults. The query optimizer also uses…

Read more

0 comments, 89 reads

Posted in TSQL Circle Live on 23 December 2016

Clustered Columnstore Index really hates Updates

First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2 dimension. Weird right? But I have a good reason for this: it’s a snapshot table and if I would create the snapshots like you’re supposed to (by exploding the fact… Read more

2 comments, 1,881 reads

Posted in Koen Verbeeck on 23 December 2016

Indexes optimize for the system databases

Maintenance of the system databases in SQL Server regarding the indexes is important too. The system tables also have indexes and their maintenance is of asset on busy environments.
It’s important to know that the indexes in msdb and master are marked as system objects, so if you have your…

Read more

0 comments, 373 reads

Posted in SQL Mighty on 23 December 2016

ReadyRoll Development

This is the sixth part in the series: SQL Server and Continuous Integration. This post will illustrate the power of ReadyRoll when developing database projects. Topics covered so far in this series are:

For this post, I will be starting a new… Read more

0 comments, 1,005 reads

Posted in The Database Avenger on 23 December 2016

What Agent Job is Running – Back to Basics

Remember When…

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

0 comments, 1,785 reads

Posted in SQL RNNR on 23 December 2016

Merry Christmas

Yesterday was the last working day before Christmas  at GRE Towers. We’ve got today off. So this is just a short post for the Friday before Christmas. 

Christmas Tree at GRE Towers
Wishing you all a very merry Christmas.

Read more

0 comments, 278 reads

Posted in The SQL DBA in the UK on 23 December 2016

Quick Command Shells–#SQLNewBlogger

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

This isn’t a SQL post, per se, but since I’ve been using lots of PowerShell for SQL stuff at times, this is a handy trick I picked… Read more

1 comments, 364 reads

Posted in The Voice of the DBA on 22 December 2016

Windows Server 2016 and SQL Server 2016 – A match made in heaven!

For all these years Windows Server 2016 is the Windows version I was waiting for, and this blog post will explain why I’m super excited about this!

With Windows Server 2016, you can now create a Windows Cluster with nodes in multiple domains. Or even without a domain (Workgroup).

With… Read more

0 comments, 614 reads

Posted in SQLSailor.com on 22 December 2016

SSIS Custom Logging Levels

In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For users of later versions (2012 and beyond) of SQL Server Integration Services, adding logging to those ETL processes is very simple. Since logging is managed by the catalog, adding logging… Read more

5 comments, 284 reads

Posted in Tim Mitchell on 22 December 2016

Database Backups – Back to Basics

Remember When…

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

0 comments, 506 reads

Posted in SQL RNNR on 22 December 2016

Newer posts

Older posts