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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,907,337 DBAs, developers and SQL Server users

Rss
Headlines today   September 25, 2018

Renaming a Schema in SQL Server

If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.  Read more...
By Steve Jones 2018/09/25 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 443 reads

Adaptive Query Processing in SQL Server

Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,180 reads
Previous headlines

Uploading On-Premise data to Azure Blob Storage using SSIS

Azure SSIS Feature pack can be used to upload the data over to Azure Storage account. In this article, Supriya Pande will describe how you can upload the data to Azure Blob Storage using SSIS task.  Read more...
Rating: |  Discuss |   Briefcase | 261 reads

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps.  Read more...
By 2018/09/24 (first published: 2018/08/31) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 9,405 reads

Questions About HIPAA That You Were Too Shy to Ask

As a data professional or developer, you will likely have questions about how HIPAA impacts you and your day to day responsibilities. Rebecca Edwards answers common questions about HIPAA that you were too shy to ask.  Read more...
By Additional Articles 2018/09/24 | Source: SimpleTalk | Category: hipaa
Rating: (not yet rated)  Rate this |   Briefcase | 1,332 reads

Learning R in SQL Server

Learn about the new R Services in SQL Server 2016  Read more...
By Site Owners 2018/09/21 (first published: 2016/01/04) | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 5,656 reads

Locks Taken During Indexed View Modifications

Careful adding tables into your indexed views.  Read more...
By Additional Articles 2018/09/21 | Source: Brent Ozar Unlimited Blog | Category: locks
Rating: (not yet rated)  Rate this |   Briefcase | 1,328 reads

Adding User Comments to Reports in SQL Server Reporting Services

In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.  Read more...
By Additional Articles 2018/09/21 | Source: MSSQLTips.com | Category: comments
Rating: (not yet rated)  Rate this |   Briefcase | 1,717 reads

Identifying the right Service tier for Azure Database

Determining the number of DTUs which will help in deciding the service tier for Azure SQL.  Read more...
By Deepak Prasad Sahu 2018/09/20 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 361 reads

Pseudonymizing a Database with Realistic Data for Development Work

In this article Phil Factor shows us how to surgically alter data from an entire database that can identify individuals but leave everything else intact.  Read more...
By 2018/09/20 | Source: Redgate | Category: sql data generator
Rating: (not yet rated)  Rate this |   Briefcase | 2,331 reads
 

From the SQLServerCentral Blogs

The real differences between Dynamics 365 Operations Embedded Power BI and BYOD Power BI

I get asked this question all the time in my work as I am the BI consultant in Dynamics 365...  Read more...
By terrychoo 2018/09/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,527 reads

Power BI Monthly Digest – September 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...  Read more...
By Devin Knight 2018/09/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,460 reads
Question of the Day

Query the Column Set

By Steve Jones 2018/09/25 | Category: column sets
Rating: (not yet rated) |  Discuss |   Briefcase | 363 reads

I have this table:


CREATE TABLE UserConfig
( UserConfigKey INT IDENTITY(1,1) NOT NULL CONSTRAINT UserConfigPK PRIMARY KEY
, UserID INT
, IsActive BIT SPARSE
, IsSubscriber BIT SPARSE
, DefaultQuantity INT SPARSE
, Options XML COLUMN_SET FOR...  Read more...
Latest forum posts