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

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

How to monitor the impact of patching on SQL Server performance

In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate.  Read more...
By 2018/02/13 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,492 reads

A Simple Introduction to Dynamic SQL

Dynamic SQL is essentially normal SQL written in such a way that you end up with a “customised” SQL script at run-time.  Read more...
By Paulo de Jesus 2018/02/12 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,297 reads

Production Scripts

Many of us have scripts that we run in SQL Agent jobs, but Steve wonders if we really treat them like production code.  Read more...
By Steve Jones 2018/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

How to Implement Dynamic Data Masking in Azure SQL Database and SQL Server

Anoop Kumar shows you the SQL Commands (T-SQL) to secure PII/PHI data using the SQL Server Dynamic Data Masking (DDM) feature and explores DDM's built in functions to mask all critical data elements. DDM restricts unauthorized users from accessing critical data with no changes in the application.  Read more...
By Additional Articles 2018/02/12 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,167 reads

Database Taming

Sometimes a database can seem to be as willful as a colt. Taming it requires an iron nerve, and unflinching eye contact. Occasionally though, you need to know when to jump the fence and regroup.  Read more...
By Phil Factor 2018/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

Baselining a ReadyRoll project from an existing database

When creating a new ReadyRoll project, the schema of your production environment can also be imported as a baseline. Further work can be built on top of the baseline in a sandbox development environment and, when you’re happy with the changes, the project can be deployed to production.  Read more...
By 2018/02/12 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,769 reads

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.  Read more...
By Igor Micev 2018/02/09 (first published: 2016/07/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,911 reads

What to Read in 2018

Steve loves to read all sorts of books and is asking what books you'd read professionally or for fun in 2018.  Read more...
By Steve Jones 2018/02/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Azure Cosmos DB Consistency Levels

The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providing support for bounded-staleness, session, and consistent prefix models.  Read more...
By Additional Articles 2018/02/09 | Source: Database Journal | Category: cosmosdb
Rating: (not yet rated)  Rate this |   Briefcase | 1,721 reads

Bringing DevOps to the database. Part 2: Continuous delivery

Many application developers already use continuous integration to automatically test their code, and release management tools to automate application deployment. Database developers can join them.  Read more...
By 2018/02/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,098 reads

Webinar: How the GDPR will impact your software delivery processes

With the GDPR enforcement date looming, organisations are focusing on how data is used internally. This webinar will explain the principals of data protection, translate the GDPR jargon, and cover the steps you'll need to consider to ensure compliance in your software delivery process.  Read more...
By 2018/02/09 | Source: Redgate | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 3,915 reads

The Learning Choice

R or Python? Or both? Neither? Where should you spend your learning effort?  Read more...
By Steve Jones 2018/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 60 reads

Adaptive Query Processing – Interleaved Execution

Interleaved Execution allows SQL Server's query optimizer to get accurate cardinality estimates in places where it couldn't before.  Read more...
Rating: |  Discuss |   Briefcase | 587 reads

Mobile Report Publisher – Dashboards Everywhere

The new feature, Mobile Reports, was added to SSRS in 2016. It provides the ability to create attractive and useful dashboards that can run on devices and most browsers. Robert Cain shows you how to get started building Mobile Reports with the Mobile Report Publisher.  Read more...
By Additional Articles 2018/02/08 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 2,831 reads

Introducing database automation with the SQL Toolbelt

In this post, Mary Robbins explains how Absa bank improved development efficiency and minimized risk by implementing SQL Toolbelt.  Read more...
By 2018/02/08 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,265 reads

Hint Word Search

This is a word search for most (but not all) of the hints available in T-SQL.  Read more...
By Kenneth Fisher 2018/02/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.  Read more...
By Gregory Larsen 2018/02/07 (first published: 2015/06/24) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,004 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2018/02/07 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 101,189 reads

Heaps, Deletes, and Optimistic Isolation Levels

Erik shows that heaps have even more drawbacks under optimistic concurrency.  Read more...
By Additional Articles 2018/02/07 | Source: Brent Ozar Unlimited Blog | Category: heaps
Rating: (not yet rated)  Rate this |   Briefcase | 2,462 reads

How to use the SQL Prompt snippet placeholders for selecting and copying text

There are four SQL Prompt snippet placeholders that are all about selection and copying of text. These placeholders are very handy if, for example, you have two blocks of code that need to be part of a snippet. One part you hold on the clipboard, and the other part is a block of snippet text, selected using the $SELECTEDTEXT$ placeholder.  Read more...
By 2018/02/07 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,932 reads
<< Newer    Items 21 to 40 of 16544    Older >>