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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,900,190 DBAs, developers and SQL Server users

Rss
Headlines today   April 27, 2018

Powershell To Get Active Directory Users And Groups into SQL

Use Powershell to query AD for Users, Groups and GroupMembers  Read more...
By Lowell Izaguirre 2018/04/27 (first published: 2016/03/31) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 4,414 reads

SQL Server Closure Tables

SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information that is important to the relationship between objects. In this article, Phil Factor explains how to use closure tables to overcome this deficiency.  Read more...
By Additional Articles 2018/04/27 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 298 reads

Deliver GDPR-compliant data to SQL Server teams

The GDPR makes it essential for SQL Server teams to maintain a living data catalog and to put in place controls and processes up front to protect personal data. But this doesn’t mean you need to lock your data away or slow down your development processes.   Read more...
By 2018/04/27 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 314 reads

A strategy for implementing database source control

Much has been written on the benefits of having a database under source control, though many articles are clear on “why” but conspicuously vague on “how”. In this ahis article, David Poole describes what was required of his organization's database source control solution, how they approached the challenges, and how using Redgate SQL Source Control as a template helped.   Read more...
By 2018/04/27 | Source: Redgate | Category: source control
Rating: (not yet rated)  Rate this |   Briefcase | 268 reads
Previous headlines

SQL Server From .Net: Building a DataSet with Code

A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.  Read more...
By Tim Wellman 2018/04/26 | Source: SQLServerCentral.com | Category: ado.net
Rating: (not yet rated) |  Discuss |   Briefcase | 144 reads

Missing Index Impact and Join Type

Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.  Read more...
By Additional Articles 2018/04/26 | Source: Brent Ozar Unlimited Blog | Category: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 3,513 reads

Hash Join Memory Grant Factors

Remember when that old DBA told you not to SELECT *? Erik Darling explains why.  Read more...
By Additional Articles 2018/04/26 | Source: Brent Ozar Unlimited Blog | Category: hash join
Rating: (not yet rated)  Rate this |   Briefcase | 1,039 reads

Detecting Problems on Databases that use Snapshot-based Transaction Isolation

If you’re using SQL Server’s Read Committed Snapshot Isolation level (RCSI) to avoid long waits for a blocked resource, then you’ll want to monitor for possible side effects. This article describes one way to monitor for such problems, using an alert on version_ghost_record_count, to warn us when the number of row versions in tempdb is getting very high.  Read more...
By 2018/04/26 | Source: Redgate | Category: read committed snapshot isolation
Rating: (not yet rated)  Rate this |   Briefcase | 885 reads

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.  Read more...
By Ben Miller 2018/04/25 (first published: 2015/12/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,575 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2018/04/25 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 46,647 reads
 

From the SQLServerCentral Blogs

Why Don't I have a Preferred Replica?

The client reported that the log file on their main database was growing unusually large, and when they checked the...  Read more...
By Andy Galbraith 2018/04/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 482 reads

Python Jupyter Notebooks in Azure

There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I...  Read more...
By Steve Jones 2018/04/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,300 reads
Question of the Day

Filtering a CAST

By Steve Jones 2018/04/27 | Category: cast and convert
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

I have a set of data like this:


CREATE TABLE CastTest
(
Myval VARCHAR(20)
);
GO
INSERT CastTest
(
Myval
)
VALUES
('A') ,
('My Test') ,
('123') ,
('123.5') ,
('20180301') ,
('Mar 23, 2000'),
('Jan 1, 2000');
GO
I decide to filter my data...  Read more...
Latest forum posts