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

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

Using Tools that Fit

Equipment can matter for IT professionals. Read a few thoughts from Andy Warren.  Read more...
By Andy Warren 2017/09/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 50 reads

The Shortcomings of Predictive Accuracy

In prediction, accuracy is key. But it's not all it's cracked up to be as we will explore.  Read more...
By Nick Burns 2017/09/07 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 697 reads

Why don’t you unit test SQL Server code?

This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your database code more robust to change.  Read more...
By Additional Articles 2017/09/07 | Source: Redgate | Category: unit testing
Rating: (not yet rated)  Rate this |   Briefcase | 4,937 reads

SQL Graph Objects in SQL Server 2017: the Good and the Bad

Graph databases are useful for certain types of database tasks that involve representing and traversing complex relationships between entities. These can be difficult to do in relational databases and even trickier to report on. Until now, we have had the choice of doing it awkwardly in SQL Server or having an ancillary database to tackle this type of task. SQL Server 2017 will be bringing graph capabilities to the product but will these features prove to be good enough to allow us to dispense with specialised Graph databases? Dennes Torres decided to find out.  Read more...
By Additional Articles 2017/09/07 | Source: SimpleTalk | Category: sql server 2017
Rating:  Rate this |   Briefcase | 2,834 reads

SQL Security Crossword

Crossword puzzle focusing on SQL Server Security  Read more...
By Kenneth Fisher 2017/09/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 106 reads

Using SQL Server Dynamic Online Catalog to Explore Keys and Relationships: Stairway to Exploring Database Metadata Level 4

This level introduces keys, constraints, and relationships.  Read more...
By Phil Factor 2017/09/06 (first published: 2016/10/19) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,547 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2017/09/06 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 29,798 reads

Five Mistakes Performance Tuners Make

Erik Darling explains why your queries aren't scaling in production.  Read more...
By Additional Articles 2017/09/06 | Source: Brent Ozar Unlimited Blog | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,711 reads

Azure DWH part 15: PolyBase and Azure Data Lake

In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.  Read more...
By Daniel Calbimonte 2017/09/05 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 312 reads

What is your definition of a DBA?

How would you define a DBA role? Here are some of my thoughts.  Read more...
By Ben Kubicek 2017/09/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 85 reads

Register for the Redgate Hub Launch Livestream on September 6

To celebrate the launch of the new Redgate Hub, Data Platform MVP Steve Jones is hosting an educational livestream event alongside the team at Redgate HQ. They’ll introduce you to everything the Redgate Hub has to offer by highlighting some recent technical articles and how-to guides with in-depth live presentations. Register now.  Read more...
By 2017/09/05 (first published: 2017/08/24) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 5,390 reads

Introduction to Azure Cosmos DB

Azure Cosmos DB is the latest data service offering from Microsoft. Azure Cosmos DB is a super set of DocumentDB and provides a new set of capabilities. These capabilities make Azure Cosmos DB stand out from other members in the NoSQL database family.  Read more...
By Additional Articles 2017/09/05 | Source: Database Journal | Category: azure cosmos db
Rating: (not yet rated)  Rate this |   Briefcase | 2,777 reads

The End of Summer

Today Steve Jones talks a bit about the US Labor Day holiday.  Read more...
By Steve Jones 2017/09/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 38 reads

Time Traveling with Temporal Tables on SQL Server 2016

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.  Read more...
By Johan Åhlén 2017/09/04 (first published: 2016/10/18) | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 3,363 reads

SQL Server in Space - HASSP

A successful launch, and recovery, of SQL Server running below a balloon.  Read more...
By Steve Jones 2017/09/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 37 reads

Protecting production data in non-production environments

In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment.  Read more...
By Additional Articles 2017/09/04 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,899 reads

Statistics in SQL: The Mann–Whitney U test

Phil Factor shows how to use the Mann-Whitney U test in SQL to to find out whether two samples come from the same distribution.  Read more...
By Additional Articles 2017/09/04 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 3,290 reads

PowerShell Tool Time: Our First Toolbox

Learn how to begin assembling your functions and code into modules you can easily call from any session.  Read more...
By Mike Fal 2017/09/01 (first published: 2015/10/28) | Source: SQLServerCentral.com | Category: powershell tool time
Rating: |  Discuss |   Briefcase | 7,131 reads

Improving Log Shipping

Today Steve Jones looks at possible ways to improve log shipping and asks for your input as well.  Read more...
By Steve Jones 2017/09/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

What is the biggest mistake you made in production?

When you have sysadmin access, you are bound to make a big mistake in production at some point in your career - in this post Tara Kizer looks back at what hers were.  Read more...
By Additional Articles 2017/09/01 | Source: Brent Ozar Unlimited Blog | Category: mistakes
Rating: (not yet rated)  Rate this |   Briefcase | 4,461 reads
<< Newer    Items 41 to 60 of 16097    Older >>