Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,743,926 DBAs, developers and SQL Server users

Rss
Headlines today   August 20, 2014

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,395 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/08/20 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 20,113 reads

Quickly Investigating What's in the Tables of SQL Server Databases

From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.  Read more...
By Additional Articles 2014/08/20 | Source: SimpleTalk | Category: tables
Rating: (not yet rated)  Rate this |   Briefcase | 4,343 reads
Previous headlines

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 7,038 reads

SQL Monitor Custom Metric: Out of memory errors

The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of memory errors alert when it gets registered there.  Read more...
By Press Release 2014/08/19 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,271 reads

Newsletter Changes - Reducing Size

A change to the newsletter is coming soon.  Read more...
By Site Owners 2014/08/19 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 746 reads

How to configure SSL encryption in SQL Server

Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.  Read more...
By Additional Articles 2014/08/19 | Source: MSSQLTips.com | Category: ssl
Rating: (not yet rated)  Rate this |   Briefcase | 5,372 reads

Automate Your Central Management Server Registrations

Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.  Read more...
By S. Kusen 2014/08/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,790 reads

Common database deployment blockers and Continuous Delivery headaches

Deployability is now a first class concern for databases, so why isn’t it as easy as it should be? Matthew Skelton explores seven of the most common challenges which will bring your database deployments to their knees.  Read more...
By Additional Articles 2014/08/18 | Source: SimpleTalk | Category: database deployment
Rating: (not yet rated)  Rate this |   Briefcase | 6,373 reads

SQL Saturday #300 - Kansas City

SQL Saturday is coming to Kansas on September 13, 2014. Our very own Steve Jones will be presenting, alongside other big names like Glenn Berry, Kathi Kellenberger, Sean and Jen McCown, Jason Strate, and many more. Register while space is available.  Read more...
By Press Release 2014/08/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,268 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Database Creation using Create Database command

In SQL Server, database can be created by 2 ways:-  Using Create Database command Using SQL Sever Management Studio (SSMS). In this article,...  Read more...
By Vivek Johari 2014/08/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,873 reads

Effects of sp_rename on Stored Procedures

There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during...  Read more...
By Jason Brimhall 2014/08/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,110 reads
Question of the Day

DBCC CHECKDB

By Dan Hess 2014/08/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 759 reads

Select the statements that are true about running the following command (select 2):


DBCC CHECKDB('myDatabase') with TABLOCK  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
SQLRNNR
436 21619 SSC-Insane  
2.
cruice
374 699 SSChasing Mays  
3.
GilaMonster
344 42756 SSC-Forever  
4.
Eirikur Eiriksson
327 1536 SSCommitted  
5.
Koen Verbeeck
286 13538 SSChampion  
Latest forum posts