SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2018/04/04 to 2018/04/11

Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security

In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.  Read more...
By Steve Jones 2018/04/11 | Source: SQLServerCentral.com | Category: row-level security (rls)
Rating: |  Discuss |   Briefcase | 937 reads

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,961 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2019/01/16 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 82,179 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,427 reads


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,920 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,855 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,356 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,500 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,948 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,974 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,121 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 | 3,082 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,201 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 | 2,223 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 2019/03/20 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 54,464 reads