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

<< Newer    Items 21 to 40 of 14117    Older >>

A Pattern for Email Address storage and retrieval

Email addresses are very prevalent in IT systems and often used as a natural primary key. The repetitive storage of email addresses in multiple tables is a bad design choice. Following is a design pattern to store email addresses in a single table and to retrieve them efficiently.  Read more...
By Jeff Reinhard 2015/09/24 | Source: | Category: email address
Rating: |  Discuss |   Briefcase | 5,090 reads

OpenStack: The Good and Not-So-Good Bits

OpenStack holds a great deal of promise as a cloud platform built on open standards, and has support from the major players in cloud services. It has the potential for allowing organisations to set up their own private cloud services that are designed to inter-operate. Is it ready yet for companies that want the convenience of cloud solutions, but with more control, and without the large subscription fees? Robert Sheldon finds out.  Read more...
By Additional Articles 2015/09/24 | Source: SimpleTalk | Category: openstack
Rating: (not yet rated)  Rate this |   Briefcase | 3,021 reads

Data Masking for Convenience

Steve Jones talks a bit about the new data masking feature in SQL Server 2016 and how useful it can be.  Read more...
By Steve Jones 2015/09/24 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Stairway to SQL Server Security Level 11: Auditing

By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway level you’ll learn how to define the various audit specification objects, how to capture audit data, and how to explore and use the data.  Read more...
By Don Kiely 2015/09/23 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,167 reads

Retrieve file sizes from the file system using Power Query

Koen Verbeeck shows how to easily extract metadata from files in your directories with Power Query.  Read more...
By Additional Articles 2015/09/23 | Source: | Category: power query
Rating: (not yet rated)  Rate this |   Briefcase | 2,038 reads

Everyone is a Target

Today Steve Jones looks at the targeted attacks by hackers against individual security professionals.  Read more...
By Steve Jones 2015/09/23 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 105 reads

Data Sprawl

The challenges of data growth and sprawl can be compounded by the variety of tools and platforms available. Steve Jones notes that you might need to learn a bit about different technologies.  Read more...
By Steve Jones 2015/09/22 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 95 reads

Implementing John Conway's Game of Life in Microsoft SQL Server

A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation  Read more...
By Paul Chang 2015/09/22 | Source: | Category: cte
Rating: |  Discuss |   Briefcase | 4,458 reads

Free webinar: DLM Demo

Redgate’s Database Lifecycle Management solution ensures database changes made in development environments are always tested and reviewed before being deployed, and adds automation to the process. Find out how by joining Steve Jones, MVP and editor of SQLServerCentral, as he demonstrates the solution and shows why such an approach is essential if you want to release changes frequently.  Read more...
By Additional Articles 2015/09/22 (first published: 2015/08/11) | Source: Redgate | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 7,461 reads

Interesting things about INSTEAD OF triggers

This article from Paul White examines some surprising behaviour of INSTEAD OF triggers and reveals a serious cardinality estimation bug in SQL Server 2014.  Read more...
By Additional Articles 2015/09/22 | Source: | Category: instead of trigger
Rating: (not yet rated)  Rate this |   Briefcase | 2,821 reads

Baseline Collector Solution V2

New version of the Free Baseline Collector Solution released. Do you collect baseline data? If not, let's start doing it!  Read more...
By Robert Virag 2015/09/21 | Source: | Category: baseline
Rating: |  Discuss |   Briefcase | 3,255 reads

Data Liability

The issue of who owns data, and who is responsible is one that our world hasn't defined well. Steve Jones has a few thoughts on potential issues for data professionals.   Read more...
By Steve Jones 2015/09/21 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

Learning Stretch Database

References and links about the Stretch to Azure feature in SQL Server 2016.  Read more...
By Site Owners 2015/09/21 | Source: | Category: stretch database
Rating: |  Discuss |   Briefcase | 1,103 reads

How to Confuse the SQL Server Query Optimizer

Want to 'trick' SQL Server into performing millions of logical reads to return data, when only are few thousand were really required? In this article, Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the point that it generates and reuses very inefficient execution plans.  Read more...
By Additional Articles 2015/09/21 | Source: SimpleTalk | Category: query optimizer
Rating:  Rate this |   Briefcase | 2,937 reads

Whatever happened to Database Table Refactoring?

Phil Factor ponders why most people lost their initial enthusiasm for refactoring databases iteratively, in parallel with the evolutionary design of the rest of the system.  Read more...
By Phil Factor 2015/09/21 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 92 reads

Logging and Error Handling for SQL Stored Procedures

Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure  Read more...
By Dwain Camps 2015/09/18 (first published: 2014/01/20) | Source: | Category: error handling
Rating: |  Discuss |   Briefcase | 17,403 reads

The Counter Offer - Part 2

Today we have a guest editorial from Andy Warren that takes another view of the counter offer from your employer.  Read more...
By Andy Warren 2015/09/18 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 192 reads

T-SQL Window Functions Speed Phreakery

Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process large amounts of data. Do we need these techniques now that we can express a SQL task in terms of window functions? Kathi revisits a famous SQL challenge to find out.  Read more...
By Additional Articles 2015/09/18 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,506 reads

Creating SQL databases on Azure Blob storage

Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.  Read more...
By Arun Sirpal 2015/09/17 | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 1,758 reads

Monitoring Availability Group Replica Synchronization

If you are deploying SQL Server Availability Groups, one of the important aspects of a successful deployment is monitoring the synchronization of the secondary replica databases with the primary replica - but there are multiple ways to do this. Jonathan Kehayias goes through each, explaining their different benefits and drawbacks.  Read more...
By Additional Articles 2015/09/17 | Source: | Category: availability group
Rating: (not yet rated)  Rate this |   Briefcase | 1,900 reads
<< Newer    Items 21 to 40 of 14117    Older >>