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

Welcome to

A Microsoft SQL Server community of 1,842,776 DBAs, developers and SQL Server users

Headlines today   December 2, 2015

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 2015/12/02 | Source: | Category: stairway series
Rating: (not yet rated) |  Discuss |   Briefcase | 147 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2015/12/02 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 63,245 reads

MySQL Pattern Matching using Regular Expressions

In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.  Read more...
By Additional Articles 2015/12/02 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 154 reads
Previous headlines

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
Rating: |  Discuss |   Briefcase | 3,040 reads

Doing a SQL Server Healthcheck via PowerShell

PowerShell is an ideal tool for doing health-checks of a collection of SQL Server instances, and there are several examples around, but few acknowledge the fact that individual DBAs have their own priorities for tests, and need something easily changed to suit circumstances. Omid Afzalalghom's Healthcheck allows tests to be SQL or PowerShell and requires only adding, altering or deleting files in directories.  Read more...
By Additional Articles 2015/12/01 | Source: SimpleTalk | Category: healthcheck
Rating:  Rate this |   Briefcase | 2,085 reads

Add new disks to a SQL Server Failover Cluster on Windows 2008

This article shows the procedure to Add new disks to SQL Server failover cluster in windows 2008/2008R2. This article also covers how to add dependencies to a SQL Server cluster resource.  Read more...
By Ganapathi varma 2015/11/30 | Source: | Category: cluster
Rating: |  Discuss |   Briefcase | 983 reads

Introduction to Storage Spaces Direct for SQL Server

Glenn Berry introduces the exciting new feature in Windows Server 2016 called Storage Spaces Direct (S2D), which enables organizations to use multiple, clustered commodity file server nodes to build highly available, scalable storage systems with local storage, using SATA, SAS, or PCIe NVMe devices.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,497 reads

Your Usage of the Microsoft Data Platform

Microsoft has been rapidly extending its data offering to what is now a comprehensive “data platform” intended to provide the building blocks for customers to build and extend more complex and “intelligent” applications. Redgate are conducting research on the use and adoption of the data platform and have put together a short two-page survey. They're interested in your feedback even if you haven’t started using the data platform just yet, but have some interest in moving in that direction.  Read more...
By 2015/11/30 (first published: 2015/11/27) | Source: Redgate | Category: microsoft data platform
Rating: (not yet rated)  Rate this |   Briefcase | 2,823 reads

Stairway to SQLCLR Level 1: What is SQLCLR?

The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.  Read more...
By Solomon Rutzky 2015/11/27 (first published: 2014/01/09) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,729 reads

Programmatically changing SQL Server linked tables in Microsoft Access

Tim Wise explains how Microsoft Access provides a quick and easy way to create a simple front end for a SQL Server database by pointing linked tables to the SQL Server.  Read more...
By Additional Articles 2015/11/27 | Source: | Category: microsoft access
Rating: (not yet rated)  Rate this |   Briefcase | 1,674 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Server 2005 End of Support and Business Intelligence

How does the official end of support for SQL Server 2005 affect companies using Reporting Services, Analysis Services and other...  Read more...
By pturley 2015/12/02 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 143 reads
Question of the Day

Moving the Resource Database

By Junior Galvão - MVP 2015/12/02 | Category: resource database
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads
Can theResourcesystem databaseon theMicrosoft SQLServer be movedto a differentdisk drive orfolder?
Top Members (last 30 days)
# Name Score Level
30 days All-time
898 1531 SSCommitted  
Iwas Bornready
339 5956 SSCertifiable  
269 521 Mr or Mrs. 500  
Luis Cazares
269 6005 SSCertifiable  
Ed Wagner
266 7177 SSCertifiable  
Latest forum posts