Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 61 to 80 of 15575    Older >>
 

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.  Read more...
By Additional Articles 2017/03/08 | Source: MSSQLTips.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,560 reads

Detective Stories - Tracking Down the Database's Dependents Part 2

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/07 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 762 reads

Actionable Metrics

Metrics should help you learn, or otherwise change the behavior of the system.  Read more...
By Steve Jones 2017/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

SSIS Catalog Compare v2.0 Launch Event

Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.  Read more...
By Press Release 2017/03/07 (first published: 2017/03/03) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 4,998 reads

Query Store and In-Memory OLTP

Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.  Read more...
By Additional Articles 2017/03/07 | Source: SimpleTalk | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 3,958 reads

Detective Stories - Tracking Down the Database's Dependents Part I

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/06 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 1,095 reads

Containing the Work

Containers are valuable in many software domains. Are there places we, as data professionals, would like to use software containment?  Read more...
By Steve Jones 2017/03/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 49 reads

Project Bletchley - The Microsoft Vision for Blockchain

The SQL Server Luxembourg User Group invites you to join us at our next event in Microsoft’s Offices, at 6:00pm on Tuesday 7th March  Read more...
By Press Release 2017/03/06 | Source: SQLServerCentral.com | Category: user groups
Rating: |  Discuss |   Briefcase | 456 reads

Finding the Worst Performing TSQL Statement

Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.  Read more...
By Additional Articles 2017/03/06 | Source: Database Journal | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 4,594 reads

Creative IT Learning

If a successful IT career is just as much about tenacity, interest and retention as it is about brainpower, then how does one go about continuous learning?  Read more...
By Phil Factor 2017/03/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

Usage of CTE - Trick with Dates

This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.  Read more...
By Suresh Maganti 2017/03/03 (first published: 2013/06/18) | Source: SQLServerCentral.com | Category: cursor vs recursive cte
Rating: |  Discuss |   Briefcase | 34,163 reads

Null Defaults

Today Steve Jones asks what default values you might choose for new columns in a table.  Read more...
By Steve Jones 2017/03/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 101 reads

SSIS Catalog Compare v2.0 Launch Event

Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.  Read more...
By Press Release 2017/03/07 (first published: 2017/03/03) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 4,998 reads

Clone a SQL Server login and password to a new server

Bhavesh Patel shows how to clone a SQL Server login onto another server while keeping the password the same.  Read more...
By Additional Articles 2017/03/03 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 4,312 reads

Configure SSRS with an SSL Certificate

A short demonstration on how to configure Reporting Services (SSRS) with an SSL certificate.   Read more...
By Thomas Liddle 2017/03/02 | Source: SQLServerCentral.com | Category: ssrs
Rating: |  Discuss |   Briefcase | 903 reads

How to Programmatically Determine Which Edition of SQL Server is Installed

Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.  Read more...
By Additional Articles 2017/03/02 | Source: Database Journal | Category: sql server versions
Rating:  Rate this |   Briefcase | 3,515 reads

Why I am Excited about SQL Server on Linux

Read why Solomon Rutzky is excited about SQL Server running on Linux.  Read more...
By Solomon Rutzky 2017/03/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 89 reads

Stairway to U-SQL Level 13: SQL.MAP

We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.  Read more...
By Mike McQuillan 2017/03/01 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 884 reads

Detecting Issues

How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.  Read more...
By Steve Jones 2017/03/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 87 reads

DevOps and “Shift Left” for Databases

The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least preparing for, all the processes and tasks that are necessary for deployment as soon as possible in the development cycle, it is possible to move from big, infrequent releases to “little and often”. Stephanie Herr explains how ‘shifting left’ can get deployment pipelines moving.  Read more...
By Additional Articles 2017/03/01 | Source: SimpleTalk | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,644 reads
<< Newer    Items 61 to 80 of 15575    Older >>