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,276 DBAs, developers and SQL Server users

Rss
Headlines today   September 24, 2018

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: (not yet rated) |  Discuss |   Briefcase | 11 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 | 8,596 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 | 201 reads
Previous headlines

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,541 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,135 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,547 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 | 342 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,156 reads

Advanced Testing of Your PowerShell Code with Pester

Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.  Read more...
By Additional Articles 2018/09/20 | Source: SimpleTalk | Category: test
Rating: (not yet rated)  Rate this |   Briefcase | 1,373 reads

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages

In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.  Read more...
By Andy Leonard 2018/09/19 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 327 reads
 

From the SQLServerCentral Blogs

Using Table Valued Parameters with sp_executesql

Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to...  Read more...
By Kenneth Fisher 2018/09/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 551 reads

Them Con+cat+enatin’ Blues

We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...  Read more...
By Roland Alexander STL 2018/09/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,612 reads
Question of the Day

sp_rename and stored procedures

By Thomas Franz 2018/09/24 | Category: sp_rename
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads

What will the query in the following statements return (tested on SQL 2017):


CREATE PROCEDURE dbo.test AS PRINT 1;
GO
EXEC sys.sp_rename @objname = 'dbo.test',
@newname = 'test2',
@objtype = 'OBJECT';

GO
SELECT sm.definition
FROM sys.sql_modules AS sm
...  Read more...
Latest forum posts