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

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

Software Testing Skills Must Shift with AI

Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.  Read more...
By Additional Articles 2018/04/11 | Source: SimpleTalk | Category: artificial intelligence (ai)
Rating: (not yet rated)  Rate this |   Briefcase | 2,776 reads

The Best Ever

Steve wants to know which version of SQL Server you like the best.  Read more...
By Steve Jones 2018/04/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 57 reads

TRIM() in T-SQL

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.  Read more...
By Steve Jones 2018/04/10 | Source: SQLServerCentral.com | Category: trim()
Rating: |  Discuss |   Briefcase | 1,792 reads

“Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps

Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.  Read more...
By Additional Articles 2018/04/10 | Source: Brent Ozar Unlimited Blog | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 4,540 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/10 | Source: Database Journal | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 3,172 reads

What's Downtime?

Steve asks the question today of how you might measure downtime and the scope you are concerned about.  Read more...
By Steve Jones 2018/04/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Stumbling over Words

Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.  Read more...
By Phil Factor 2018/04/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.  Read more...
By David Strack 2018/04/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,273 reads

Mount SQL Server DMVs and Custom Queries Using DBFS on Linux

With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux, and Linux administrators will need to learn how to work with SQL Server. Fortunately, there are several tools available to assist. In this article Prashanth Jayaram describes how to work with the DMV tool which treats queries as files.  Read more...
By Additional Articles 2018/04/09 | Source: SimpleTalk | Category: sql server on linux
Rating: (not yet rated)  Rate this |   Briefcase | 2,237 reads

How to execute a Powershell script via SSIS

Learn how you can execute a PowerShell script via the SSIS execute process task.  Read more...
By Perry Whittle 2018/04/06 (first published: 2015/12/03) | Source: SQLServerCentral.com | Category: execute process task
Rating: |  Discuss |   Briefcase | 5,658 reads

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,779 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,041 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,889 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 | 127 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,011 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,341 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,850 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
<< Newer    Items 41 to 60 of 16732    Older >>