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

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

Why Redgate is Running a Database Development Disasters Contest?

Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.   Read more...
By Kendra.Little 2019/02/14 | Source: SQLServerCentral.com | Category: redgate
Rating: (not yet rated) |  Discuss |   Briefcase | 163 reads

Using the DAX Calculate and Values Functions

In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.  Read more...
By 2019/02/14 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 1,882 reads

How to Apply Non-Standard SQL Formatting Using SQL Prompt

Like any good tool, SQL Prompt not only will format your code for you, but will also help you to format the code in an alternative manner, or to apply exceptions to certain parts of a SQL script, where the formatting applies by the current style isn't what's required.  Read more...
By 2019/02/14 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,147 reads

Google's Expensive Confusing Rules

Google was recently fined for GDPR violations. Steve wonders if their confusing documentation and tools are the problem.  Read more...
By Steve Jones 2019/02/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2019/02/13 (first published: 2016/05/11) | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 4,153 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2019/02/13 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 103,455 reads

SQL Server Perfmon counters that are still interesting in 2019

Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I’ve moved on – wait stats are a much better starting point – but there are still 3 good Perfmon counters that I rely on.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,111 reads

Provisioning Multiple Masked Databases

Addressing common challenges, Redgate’s Chris Unwin explains how to create multiple masked copies of a database, delivered as a group with SQL Provision.   Read more...
By 2019/02/13 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,520 reads

Hard Drive Reliability

Backblaze releases their new hard drive stats and there are some interesting items in the report.  Read more...
By Steve Jones 2019/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Using Computed Columns

Although computed columns are from the beginning of SQL Server, not everyone knows how to use them. This article will help you better understand how it works.  Read more...
By Luis Martin 2019/02/12 | Source: SQLServerCentral.com | Category: computed columns
Rating: |  Discuss |   Briefcase | 972 reads

The Whys and Wherefores of Untrusted or Disabled Constraints

Phil Factor explains what causes this issue, the problems it will cause and how to avoid the problem  Read more...
By 2019/02/12 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 1,866 reads

Infrastructure Planning for a SQL Server Data Warehouse

In this tip we look at some things you should think about when planning for a SQL Server data warehouse.  Read more...
By Additional Articles 2019/02/12 | Source: MSSQLTips.com | Category: data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 2,511 reads

Getting Started with Database containers

A beginning look at containers in Windows.  Read more...
By Steve Jones 2019/02/11 (first published: 2019/02/04) | Source: SQLServerCentral.com | Category: containers
Rating: |  Discuss |   Briefcase | 1,544 reads

Empty Thoughts: Working with NULL

Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is represented should be carefully considered during database design. In this article, Joe Celko considers the ways that SQL Server handles NULLs in several situations.  Read more...
By Additional Articles 2019/02/11 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,037 reads

Create, Protect and manage non-production databases with SQL Provision

SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. Tony Davis explains how SQL Provision can work alongside your existing database DevOps practices.  Read more...
By 2019/02/11 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 1,894 reads

DR Prep Can Miss the Little Things

A minor disaster for Steve reveals some cracks in his pre-DR planning.  Read more...
By Steve Jones 2019/02/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 31 reads

A Capital Error

It's not the zero'th time Phil Factor has complained about the madness of a binary collation.  Read more...
By Phil Factor 2019/02/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Using SQL Server and R Services for analyzing Sales data (Part 3)

Using R integration for analyzing sales data in WideWorldImporters database  Read more...
By Tomaž Kaštrun 2019/02/08 (first published: 2017/01/17) | Source: SQLServerCentral.com | Category: r services
Rating: |  Discuss |   Briefcase | 2,180 reads

Learn More than Technology

There is more to our lives than work, and Steve asks that we learn more about other parts of life.  Read more...
By Steve Jones 2019/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

Which Version of SQL Server Should You Use?

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?  Read more...
By Additional Articles 2019/02/08 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,824 reads
<< Newer    Items 21 to 40 of 17647    Older >>