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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,896,261 DBAs, developers and SQL Server users

Rss
Headlines today   January 23, 2018

Azure DWH part 24: Elastic queries

This article will explain what is an elastic query and show an example.  Read more...
By Daniel Calbimonte 2018/01/23 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 132 reads

Validation, Verification, and Modification

A proper database design is very important, and changes to fix problems after the fact are expensive. In this article, Joe Celko discusses three aspects of database design that are often overlooked: validation, verification, and modification.  Read more...
By 2018/01/23 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 599 reads
Previous headlines

Automatic Database Seeding

Set up and use the automatic databases seeding feature for Availability Groups.  Read more...
By Evgeny Garaev 2018/01/22 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 599 reads

Critical SQL Server Patches for Meltdown and Spectre

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.  Read more...
By Steve Jones 2018/01/22 (first published: 2018/01/05) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,701 reads

Do Disabled Indexes Affect Missing Index Recommendations?

Brent Ozar opens up the Stack Overflow database, turns on actual execution plans, and runs a query that will cause SQL Server to beg and plead for an index.  Read more...
By 2018/01/22 | Source: Brent Ozar Unlimited Blog | Category: missing index finder
Rating: (not yet rated)  Rate this |   Briefcase | 1,421 reads

Free webinar: Database DevOps demo

Microsoft MVP Grant Fritchey, and Redgate’s Arneh Eskandari, will show you how Redgate’s Database DevOps solution works to improve your database development and deployment processes. You'll see a demo of tools from Redgate's SQL Toolbelt and see how they plug into GIT, Jenkins and Octopus Deploy. There will also be plenty of time to ask Grant and Arneh questions.  Read more...
By 2018/01/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,515 reads

Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes

An introductory guide to querying files in Azure Data Lakes using Microsoft's U-SQL language.  Read more...
By Mike McQuillan 2018/01/19 (first published: 2016/06/15) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 6,581 reads

How to identify blocking in SQL Server

Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock. This forces the second connection to be blocked until the first connection completes.   Read more...
By 2018/01/19 | Source: MSSQLTips.com | Category: blocking
Rating: (not yet rated)  Rate this |   Briefcase | 3,299 reads

Keeping track of history: SQL Compare and Temporal Tables

SQL Compare 13 introduces support for deploying changes to temporal tables, which were introduced in SQL Server 2016. This means that any changes made to the definition of a temporal table in a source database, including to the retention policy for that table, will be included automatically in any deployment script that SQL Compare generates for that database.  Read more...
By 2018/01/19 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,771 reads

Introducing sp_BlitzLock: For Troubleshooting SQL Server Deadlocks

Erik Darling's new easy script lists out deadlocks, apps, queries, and the users involved.   Read more...
By 2018/01/18 | Source: Brent Ozar Unlimited Blog | Category: deadlocks
Rating: (not yet rated)  Rate this |   Briefcase | 3,045 reads
 

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 85 – Image Grid)

In this module you will learn how to use the Image Grid Custom Visual. This visual is a unique way...  Read more...
By Devin Knight 2018/01/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 742 reads

When it’s cold outside, perhaps Power BI heat maps can warm you up

(2018-Jan-13) You never know how the weather will behave itself, especially when the temperature gets dramatically changed from +10 to -10...  Read more...
By Rayis Imayev 2018/01/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 463 reads
Question of the Day

Mandatory Parameters

By Steve Jones 2018/01/23 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 156 reads

I want to make the $drive parameter of my Get-DbaFreeSpace function mandatory. What declaration should I use?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
41253 555187 SSC Guru  
2.
Jeff Moden
37971 512322 SSC Guru  
3.
Steve Jones - SSC Editor
23150 332296 SSC Guru  
4.
Grant Fritchey
17221 224100 SSC Guru  
5.
Lynn Pettis
17020 226128 SSC Guru  
Latest forum posts