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

<< Newer    Items 41 to 60 of 13947    Older >>
 

Azure SQL Database Security Features

The Microsoft Azure platform is evolving fast. Azure SQL Database is riding high on the cloud wave with new features enabled at a fast pace. In this article, Kun Cheng shares a few Azure SQL Database security features that could help developers and DBAs develop and manage a secure SQL Database solution.  Read more...
By Additional Articles 2015/07/17 | Source: SQLCAT | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 5,084 reads

Survey: What are your plans to upgrade SQL Server?

The Microsoft SQL Server product group are evaluating how to better assist with your SQL Server upgrades. With the upcoming SQL Server 2005 extended support deadline fast approaching, they want to understand how to help you migrate to a modern, supported version of SQL Server, and how to provide support and upgrades in future.   Read more...
By Additional Articles 2015/07/17 | Source: Microsoft MSDN | Category: microsoft
Rating: (not yet rated)  Rate this |   Briefcase | 4,419 reads

Resolution for SSIS Package Catastrophic Failure

Solution to overcome SSIS Package Catastrophic Failure Error  Read more...
Rating: |  Discuss |   Briefcase | 2,579 reads

10 SQL Snippets For Faster, More Effective Code

How many hours per week do you spend writing the same SQL again and again?  Read more...
By Gaurav Vohra 2015/07/16 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 4,954 reads

PowerShell Day-to-Day Admin Tasks: Monitoring Performance

By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information. By automating the process of gathering and storing appropriate counters, you can routinely check a range of devices quickly using visual tools such as PerfMon. By then creating your own counters, you can add counter-based metrics to anything that can be measured programmatically, such as services, applications, processes such as ETL, or deployments. Nicolas Prigent shows you how.  Read more...
By Additional Articles 2015/07/16 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,972 reads

Continuous Delivery In Real Life

Everyone wants to know who is actually using Continuous Deliver for their software. Today Steve Jones has a prominent example.  Read more...
By Steve Jones 2015/07/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 228 reads

Jump In

Steve Jones encourages you to help others and share your knowledge.  Read more...
By Steve Jones 2015/07/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 95 reads

Stairway to Database Source Control Level 1: Setting Up For Database Source Control

The first level of this stairway introduces the basics of source control, some common technologies and technologies, and demonstrates how to start versioning a SQL Server database.  Read more...
By Dave Green 2015/07/15 (first published: 2014/04/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,181 reads

Use Dynamic Data Masking in SQL Server 2016 CTP 2.1

SQL Server 2016 introduces a new security feature called Dynamic Data Masking (DDM). This tip describes its purpose, shows a brief example of how it works, lists some limitations, and notes how the feature has already changed since CTP 2.0 was first released in May.  Read more...
By Additional Articles 2015/07/15 | Source: MSSQLTips.com | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,161 reads

MS15-058: Vulnerabilities in SQL Server could allow remote code execution

A vulnerability has been released that can affect SQL Server 2008, 208 R2, 2012, and 2014.  Read more...
By Press Release 2015/07/15 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 5,180 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2015/07/15 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 65,581 reads

SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion

How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.  Read more...
By David Rueter 2015/07/14 | Source: SQLServerCentral.com | Category: math
Rating: |  Discuss |   Briefcase | 6,574 reads

Data or Experience

Is it more imortant to use the data or your experience? Does one have more weight than the other?  Read more...
By Steve Jones 2015/07/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

How to Get NULLs Horribly Wrong in SQL Server

NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.  Read more...
By Additional Articles 2015/07/14 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 8,113 reads

Automating SSIS Design Pattern - Stage Delimited Flat File

How long does it take to create to 100 staging packages? The answer will shock you!  Read more...
Rating: |  Discuss |   Briefcase | 5,619 reads

Learning Always Encrypted

Learn about the SQL Server 2016 Always Encrypted feature.  Read more...
By Site Owners 2015/07/13 | Source: SQLServerCentral.com | Category: always encrypted
Rating: (not yet rated) |  Discuss |   Briefcase | 1,223 reads

Trust People

Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.  Read more...
By Steve Jones 2015/07/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 279 reads

Modeling for Graph Databases

This week Steve Jones looks at modeling data in a graph database.  Read more...
By Steve Jones 2015/07/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 82 reads

Knee-Jerk Wait Statistics : CXPACKET

With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.  Read more...
By Additional Articles 2015/07/13 | Source: SQLServerCentral.com | Category: cxpacket
Rating:  Rate this |   Briefcase | 2,723 reads

Data Loss or Downtime

This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.  Read more...
By Steve Jones 2015/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 217 reads
<< Newer    Items 41 to 60 of 13947    Older >>