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

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

Specialist or Generalist

The idea of being a generalist of specialist may not need to be a choice.  Read more...
By Steve Jones 2016/04/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 93 reads

Announcing Bilm Academy

Join Andy Leonard the week of May 9-13 for 5 free days of Biml training.   Read more...
By Press Release 2016/05/02 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 2,929 reads

The Practical Problems of Determining Equality and Equivalence in SQL

In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.  Read more...
By Additional Articles 2016/04/26 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 3,384 reads

The Pen Test

Perhaps a penetration test is a good idea for more organizations.  Read more...
By Steve Jones 2016/04/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 79 reads

Verify SQL Backups With SQL Powershell

With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.   Read more...
By Geoff Ruble 2016/04/25 | Source: SQLServerCentral.com | Category: sql backups
Rating: |  Discuss |   Briefcase | 1,789 reads

A nice whistle and flute

Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.  Read more...
By Phil Factor 2016/04/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 79 reads

Knee-Jerk Performance Tuning: Incorrect Use of Temporary Tables

Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.  Read more...
By Additional Articles 2016/04/25 | Source: SQLPerformance.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 4,638 reads

Write for SQLServerCentral - Bonus for Azure

We're always looking for articles, but here are a few ones that I'd like to see written up.  Read more...
By Site Owners 2016/04/29 (first published: 2014/09/04) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,827 reads

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2016/04/22 (first published: 2014/03/24) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 12,468 reads

Automatic SSRS report output of all report parameter combinations

You already have a SQL Server Reporting Services (SSRS) sales report that takes parameters for Country and State. Each time the report is run a user selects the specific Country and State for the report. A request has been made to deliver one report via email that includes all of the combinations for each country and state. Daniel Farina shows how to achieve this without modifying the report.  Read more...
By Additional Articles 2016/04/22 | Source: MSSQLTips.com | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 3,253 reads

Backups Over Time

Today Steve Jones talks about backups, and the challenges they present over time.  Read more...
By Steve Jones 2016/04/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Migrating an on premise SQL Server Database to Azure

For this article I want to show you how to import a BACPAC file to create a new Azure SQL Database which is Microsoft’s Platform as a Service(PaaS) offering.  Read more...
By Arun Sirpal 2016/04/21 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,125 reads

Database Version Control

By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.  Read more...
By Additional Articles 2016/04/21 | Source: SimpleTalk | Category: version control
Rating:  Rate this |   Briefcase | 3,129 reads

Guess the RTM Build

Have some fun and guess which build will be released for SQL Server 2016.  Read more...
By Steve Jones 2016/04/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 reads

Byte Me: Inadequate Cooling

By 2016/04/20 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.  Read more...
By Gregory Larsen 2016/04/20 (first published: 2014/04/09) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,148 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2016/04/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 53,550 reads

Getting Started Tuning Performance in Azure SQL Database

Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.  Read more...
By Additional Articles 2016/04/20 | Source: SQLPerformance.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,197 reads

Crack that Encrypted Data

Ransomware is becoming an issue. Steve Jones notes DBAs need to be ready to deal with these issues.  Read more...
By Steve Jones 2016/04/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 116 reads

What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning

Ken Van Hyning is the Engineering Manager for the SQL Server tools, including SQLPS.  Read more...
By Aaron Nelson 2016/04/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,075 reads
<< Newer    Items 21 to 40 of 14685    Older >>