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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,888,359 DBAs, developers and SQL Server users

Rss
Headlines today   July 25, 2017

Azure DWH part 12: Permissions, roles, logins and users

In this article we will show some common roles and queries related to Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2017/07/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 162 reads

Containers for enhanced Data Governance and Compliance

Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.  Read more...
By Paul Stanton 2017/07/25 | Source: SQLServerCentral.com | Category: windocks
Rating: |  Discuss |   Briefcase | 123 reads

The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects

Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.  Read more...
By Additional Articles 2017/07/25 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,850 reads
Previous headlines

The Case of the Space at the End

A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?  Read more...
By Adam St. Pierre 2017/07/24 | Source: SQLServerCentral.com | Category: ansi_padding
Rating: |  Discuss |   Briefcase | 1,325 reads

Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS

Join Microsoft Data Platform MVP Steve Jones for the next Database DevOps demo webinar on July 25. He’ll be plugging Redgate tools into Visual Studio Team Services and showing how you can branch and merge your database changes. Sign up now.  Read more...
By 2017/07/24 (first published: 2017/07/20) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,960 reads

Testing DML Statements for In-Memory OLTP

Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.  Read more...
By Additional Articles 2017/07/24 | Source: SQLPerformance.com | Category: dml
Rating: (not yet rated)  Rate this |   Briefcase | 1,702 reads

SQL Server Management Studio add-ins

Complete list of useful and must have add-ins for SQL Server Management Studio - 32 SSMS add-ins  Read more...
By Konstantin Taranov 2017/07/21 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 2,189 reads

SQL Server User-Defined Functions

User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax.  Read more...
By Additional Articles 2017/07/21 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,447 reads

Resolve Network Binding Order Warning in failover cluster

In this article, I’m going to show a procedure to resolve an issue that I found while running cluster validation report. you may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.  Read more...
By Ganapathi varma Chekuri 2017/07/20 | Source: SQLServerCentral.com | Category: sql cluster
Rating: |  Discuss |   Briefcase | 267 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

Streaming ETL: SQL Change Data Capture (CDC) to Azure Event Hub

I had a recent requirement to capture and streamreal-time data changes on several SQL database tables from an on-prem SQL...  Read more...
By Rolf Tesmer (Mr. Fox SQL) 2017/07/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 466 reads

Create a Staging Load with Biml

When designing the ETL architecture for new or changing systems, one of the more common needs is to create a...  Read more...
By Tim Mitchell 2017/07/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 771 reads
Question of the Day

The Current Date

By Steve Jones 2017/07/25 | Category: date manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 473 reads

What datatype is returned by SYSDATETIME()?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
75442 226943 SSC Guru  
2.
Jeff Moden
66067 217018 SSC Guru  
3.
Steve Jones - SSC Editor
41457 147700 SSC Guru  
4.
Lynn Pettis
29712 95804 SSC Guru  
5.
Grant Fritchey
26876 99115 SSC Guru  
Latest forum posts