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

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

One Size Does Not Fit All

Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.  Read more...
By Derik Hammer 2018/04/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 152 reads

Data Retention: An Inexact Art

A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists.  Read more...
By Additional Articles 2018/04/06 | Source: SimpleTalk | Category: data retention
Rating: (not yet rated)  Rate this |   Briefcase | 2,652 reads

Scripting Tables and Procedures from SSMS

Learn how you can script specific objects from SSMS and store or update them in a git repository.  Read more...
By Steve Jones 2018/04/05 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 1,035 reads

Analyze entity data flow in Power BI Desktop using Sankey charts

Siddharth Mehta looks at how and why to use Sankey charts and how this can be done in Power BI Desktop.  Read more...
By Additional Articles 2018/04/05 | Source: MSSQLTips.com | Category: power bi desktop
Rating: (not yet rated)  Rate this |   Briefcase | 2,877 reads

In Memory of Robert

In memory of Robert Davis.  Read more...
By Steve Jones 2018/04/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 94 reads

Is the DBA Title Dying?

Titles are very important to many people. Steve wonders if the main title many of us use will go away.  Read more...
By Steve Jones 2018/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

Stairway to Biml Level 4: Using Biml as an SSIS Design Patterns Engine

In this level, we make a large leap forward, showing you how to use BIML to script a large number of packages using C#.  Read more...
By Andy Leonard 2018/04/04 (first published: 2013/08/14) | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 13,009 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 2018/04/04 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 42,295 reads

Controlling Access to Azure Cosmos DB

Azure Cosmos DB offers features that facilitate data availability and resiliency. However, there is also a different, very important aspect of facilitating access to distributed data sources in the most optimal manner, which focuses on access control mechanisms. Read on to learn the specifics of this aspect, as it applies to Azure Cosmos DB.  Read more...
By Additional Articles 2018/04/04 | Source: Database Journal | Category: azure cosmos db
Rating: (not yet rated)  Rate this |   Briefcase | 1,844 reads

ETL or ELT

What pattern is better for importing data? Steve discusses.  Read more...
By Steve Jones 2018/04/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 92 reads

Cache Snapshots And History Snapshots in SSRS 2016

The various Snapshot options in Reporting Services 2016 explained.  Read more...
By Suresh Kumar 2018/04/03 | Source: SQLServerCentral.com | Category: ssrs 2016
Rating: |  Discuss |   Briefcase | 399 reads

An Easier Way of Transposing Query Result in SQL Server

T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT statement, but it doesn’t quite accomplish the task. In this article, Darko Martinovic shares another method using a SQLCLR stored prodedure.  Read more...
By Additional Articles 2018/04/03 | Source: SimpleTalk | Category: sqlclr
Rating: (not yet rated)  Rate this |   Briefcase | 4,750 reads

Take the SQL Estate Data Mapping Survey and help shape Redgate’s products

Help Redgate to learn more about how SQL Server teams keep on top of sensitive data. If you're planning, or are already implementing, an information audit or data-mapping exercise for your SQL Server estate, please complete their short survey.  Read more...
By 2018/04/03 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,157 reads

Paying It Forward

Today we have a guest editorial from Andy Galbraith that looks at the ways in which he has helped others in his career.  Read more...
By Andy Galbraith 2018/04/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 222 reads

Storing a variable with a SELECT, and why it didn't work.

Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.  Read more...
By Kenneth Fisher 2018/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,768 reads

A New New Microsoft

Microsoft reorganizes their divisions again.  Read more...
By Steve Jones 2018/04/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 58 reads

How to Back Up SQL Server to Azure Blob Storage

When you’re planning for disaster recovery, offsite backups in the cloud are an attractive option. SQL Server Management Studio makes it easy to back up to the cloud inside the GUI, and you can learn how in just 90 seconds.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,772 reads

Beyond Formatting: Improving SQL Code using SQL Prompt Actions

This article shows how to use the SQL Prompt actions that you can apply as part of the Format SQL command. These actions are designed to help improve the overall quality of your SQL code, in various subtle but meaningful ways, such as qualifying object names, standardizing the use of aliases, adding semicolons to the end of statements, and removing unnecessary square brackets around object names.  Read more...
By 2018/04/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,850 reads

Exam 70-462: Using Azure for the Practice Setup

A step-by-step guide to creating a practice setup for the 70-462 exam using Azure virtual machines.  Read more...
By Nathan Bell 2018/03/30 (first published: 2015/08/25) | Source: SQLServerCentral.com | Category: certification
Rating: |  Discuss |   Briefcase | 5,139 reads

SQL Server Authenticated Users, why are we still using them?

AD Authentication in SQL Server has been around for a long time, so why do we still use SQL Authentication?  Read more...
By Ben Kubicek 2018/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads
<< Newer    Items 41 to 60 of 16722    Older >>