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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,894,795 DBAs, developers and SQL Server users

Headlines today   December 13, 2017

Stairway to SQL Server Agent - Level 3: Agent Alerts and Operators

How to be notified when a job succeeds or fails, or be notified when a SQL Server performance condition is met.  Read more...
By Richard Waymire 2017/12/13 (first published: 2011/06/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,301 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2017/12/13 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 88,975 reads

Partition Level Locking: Explanations From Outer Space

Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.  Read more...
By Additional Articles 2017/12/13 | Source: Brent Ozar Unlimited Blog | Category: partitioning
Rating: (not yet rated)  Rate this |   Briefcase | 741 reads
Previous headlines

Azure DWH part 20: Create External and Internal tables As Select

CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.  Read more...
By Daniel Calbimonte 2017/12/12 | Source: SQLServerCentral.com | Category: ctas
Rating: |  Discuss |   Briefcase | 236 reads

The four pillars of DevOps

DevOps isn’t just about tools. DevOps isn’t just about process. DevOps isn’t just about the people. DevOps isn’t just about culture. If you try and focus on one thing only, you’ll probably do it wrong and fail. You need to embrace all of the pillars. You wouldn’t build a house with only two walls and expect to have a wonderful experience the next time it rained.  Read more...
By 2017/12/12 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,031 reads

Checking SQL Server with Policy-Based Management

Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL Server instances. It's used for monitoring and enforcing a standard set of policies for SQL Server throughout an organization. While there are many built-in conditions from which to choose, Dennes demonstrates how to set up a custom policy as well as a standard one. Viewing the policy status over many servers can be tedious, so he also explains how DBAs can evaluate the states of multiple servers with just one glance.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,260 reads

SQL-On-Hadoop: Hive - Part II

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/12/11 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 517 reads

Azure SQL Database Virtual Network Service Endpoints and Rules

One of the most commonly requested Azure SQL Database features has been support for more granular control of server-level firewall settings. A recently announced public preview of Azure SQL Database and Data Warehouse VNET service endpoints and rules promises to address this limitation.  Read more...
By Additional Articles 2017/12/11 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,224 reads

Generating test data in JSON files using SQL Data Generator

SQL Data Generator is adept at filling SQL Server databases with ‘spoof’ data, for use during development and testing activities. However, what if instead of a SQL Server database full of fake data, you need a JSON file?  Read more...
By 2017/12/11 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,831 reads

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 2017/12/08 (first published: 2016/09/26) | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,287 reads

From the SQLServerCentral Blogs

Checking SQL Configuration with Pester & Dbatools

I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing...  Read more...
By Andrew Pruski 2017/12/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 735 reads

Security Architecture: Knowing the Adversary

When I present or teach on a security topic, I take the time to cover the mindset of the adversary....  Read more...
By Brian Kelley 2017/12/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,039 reads
Question of the Day

Creating Functions

By Steve Jones 2017/12/13 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 361 reads

I want to create a function in R that will return the next number of a Fibonacci sequence if I pass in the current 2. How should I write this...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
42351 496948 SSC Guru  
Jeff Moden
40116 458624 SSC Guru  
Steve Jones - SSC Editor
26104 299361 SSC Guru  
Grant Fritchey
19323 199489 SSC Guru  
Lynn Pettis
17821 201700 SSC Guru  
Latest forum posts