Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,868,470 DBAs, developers and SQL Server users

Rss
Headlines today   September 27, 2016

PowerShell Solutions - Several tips for daily tasks

In this tip, we will talk about PowerShell and SQL Server Log and Data Files.  Read more...
By Daniel Calbimonte 2016/09/27 | Source: SQLServerCentral.com | Category: datafile
Rating: |  Discuss |   Briefcase | 1,007 reads

PowerShell Desired State Configuration: DSC Resources

Desired State Configuration (DSC) allows you to automate the way that you manage configuration data for software services as well as the environment in which these services run. DSC uses a set of built-in and custom 'resources' as the building blocks for a configuration. If you have specific requirements you may need to create the relevant resource to make the configuration happen. Nicolas Prigent provides a practical guide to DSC resources.  Read more...
By Additional Articles 2016/09/27 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,031 reads
Previous headlines

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2016/09/26 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 1,076 reads

Expanding the uses of DBCC CLONEDATABASE

Erin Stellato goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 : DBCC CLONEDATABASE.  Read more...
By Additional Articles 2016/09/26 | Source: SQLPerformance.com | Category: dbcc clonedatabase
Rating: (not yet rated)  Rate this |   Briefcase | 1,795 reads

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.   Read more...
By Gregory Larsen 2016/09/23 (first published: 2015/05/27) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,962 reads

Querying Multiple MySQL Tables

It’s been said that one of the drawbacks to normalization to the third form (3NF) is more cumbersome data extraction due to the greater number of tables. These require careful linking via JOIN clauses. Improper table joining can easily result in erroneous results or even in the dreaded Cartesian Product. In today’s article, Rob Gravelle explores how table joins are achieved in MySQL.  Read more...
By Additional Articles 2016/09/23 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 2,086 reads

Audit and Compliance Survey

Redgate are trying to understand the broad problem of auditing and compliance from a database perspective. Though it's a wide-ranging topic, they're particularly interested in better understanding pain points in the area. Additional to the survey, they're also offering a $30 Amazon voucher for anyone who would be willing to participate in a short phone call.  Read more...
By 2016/09/23 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,092 reads

Monitor up-time and connectivity with Powershell

Use Powershell to troubleshoot SQL connectivity issues. A way to monitor up-time and connectivity of a SQL server database with some simple Powershell commands.  Read more...
By David Rich 2016/09/22 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 969 reads

AT TIME ZONE – a new favourite feature in SQL Server 2016

Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.  Read more...
By Additional Articles 2016/09/22 | Source: SQLPerformance.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,739 reads

Code completion, formatting and refactoring for SQL Server

A common misconception is that Redgate’s SQL Prompt is ‘just’ a code completion tool. While this is indeed at the heart of SQL Prompt, there are a host of features that will help you and your team work more quickly and efficiently, freeing you up to concentrate on the important stuff. Take a whistle stop tour around SQL Prompt in this short demo.  Read more...
By 2016/09/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,273 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 17 – Sunburst)

In this module you will learn how to use the Sunburst chart Power BI Custom Visual.  The Sunburst chart is...  Read more...
By Devin Knight 2016/09/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 688 reads

Quick Script – Finding Most Recent Backup

Recently I have had to restore a number of databases into our training environment.   Looking up each backup individually would...  Read more...
By SQLRUs 2016/09/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 546 reads
Question of the Day

U-SQL Joins

By Steve Jones 2016/09/27 | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 531 reads

What are the possible joins available in U-SQL?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
rvsc48
520 2107 SSCrazy  
2.
GP Van Eron
389 2224 SSCrazy  
3.
matthewhodson
250 354 Old Hand  
4.
Jeff Moden
203 41436 SSC-Forever  
5.
Preethi S Raj
188 1039 Ten Centuries  
Latest forum posts