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

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

SQL Server Performance Tuning Scripts, Tips and Tricks

In this webcast, Tim Smith takes a look at various tips and tricks to assist you with performance tuning your SQL Server databases. Knowing how to find and resolve problems is key to improving performance, so join him to learn how to optimize your systems  Read more...
By Additional Articles 2018/08/15 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 3,812 reads

The Master of the Schema

Go database first, not code first.  Read more...
By Steve Jones 2018/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Using pw-inspector in Brute Force attack on SQL Server

In this article we're going to explore the world of brute force attacks and pwd-inspector for tests with SQL Server  Read more...
By Anil Kuhat 2018/08/14 | Source: SQLServerCentral.com | Category: brute force
Rating: |  Discuss |   Briefcase | 803 reads

How to Remove Transparent Data Encryption From a Database

There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.  Read more...
By Additional Articles 2018/08/14 | Source: Database Journal | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,154 reads

Practical PowerShell Processes with SQL Change Automation

How to use the PowerShell cmdlets of SQL Change Automation to take the source code of a database from a directory, validate it, document it and then create a NuGet package of it.  Read more...
By 2018/08/14 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,209 reads

Why QUOTENAME is important

Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.  Read more...
By Thom Andrews 2018/08/13 | Source: SQLServerCentral.com | Category: quotename()
Rating: |  Discuss |   Briefcase | 1,813 reads

Go Unit Tests: Tips from the Trenches

In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well.  Read more...
By Additional Articles 2018/08/13 | Source: SimpleTalk | Category: go
Rating: (not yet rated)  Rate this |   Briefcase | 2,067 reads

What is NoSQL?

Steve talks about the definition of what a NoSQL database might be and where they are useful.  Read more...
By Steve Jones 2018/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

The TSB disaster: Where were the grown-ups?

Phil Factor describes how TSB performed a major public disservice with micrsoservices.  Read more...
By Phil Factor 2018/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 84 reads

The conflict between data protection and DevOps

Data breaches are the new normal – according to the Identity Theft Resource Center there were nearly 1,600 of them in 2017 in the US alone, exposing 179 million records. No wonder companies want to keep data confidential and protected. At the same time, however, the increasing pace of business means developers need to create and release code in much shorter DevOps timescales. Steve Jones discussed ways to solve this conflict  Read more...
By 2018/08/13 | Source: Redgate | Category: data protection
Rating: (not yet rated)  Rate this |   Briefcase | 1,852 reads

The Worst Day

Today Steve Jones reminisces about his career and asks you to do the same.  Read more...
By Steve Jones 2018/08/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 86 reads

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.  Read more...
By Site Owners 2018/08/10 (first published: 2015/10/05) | Source: SQLServerCentral.com | Category: for json
Rating: |  Discuss |   Briefcase | 4,489 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2018/08/10 (first published: 2016/09/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,049 reads

Common Entity Framework Problems: N + 1

Richie explains why your app is running so many queries.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,823 reads

Using a CTE as a Tally Table

Sometimes you need to output blank lines - in effect displaying Records for Missing Data. This article explains how to use a CTE to do this  Read more...
By Adam Aspin 2018/08/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,675 reads

Unwired for Weeks

Steve looks back at a few weeks of vacation.  Read more...
By Steve Jones 2018/08/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads

The Top Five Things That DBAs Need to Monitor

Being a database administrator is much more than knowing how to install SQL Server and set up a database. One of the most important responsibilities is being proactive by monitoring the instances in their care. But, what should be monitored? Here are the top five things to monitor when you are a SQL Server DBA  Read more...
By Additional Articles 2018/08/09 | Source: SimpleTalk | Category: dba
Rating: (not yet rated)  Rate this |   Briefcase | 5,349 reads

The march of DevOps from the backroom to the boardroom

By encouraging collaboration and teamwork, removing the barriers between development and operations, and introducing automation, DevOps speeds up software delivery and enables features to move from the fingers of developers into the hands of customers faster  Read more...
By 2018/08/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,426 reads

Dynamic SQL Crossword

This crossword is based on terms you might come across in an article about Dynamic SQL.  Read more...
By Kenneth Fisher 2018/08/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)

In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.  Read more...
By Hugo Kornelis 2018/08/08 (first published: 2016/11/23) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,932 reads
<< Newer    Items 21 to 40 of 17089    Older >>