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

Foundational Material: Microsoft SQL Server Book and Blogs From The Past

Erik Darling dusts off his favorite archival-quality bloggers and books.  Read more...
By Additional Articles 2018/09/07 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating:  Rate this |   Briefcase | 2,485 reads

Learn from DevOps experts at Redgate’s SQL in the City Summits this October

Make a plan to register for one of Redgate’s SQL in the City Summit’s this October, whether you choose to come to the bright lights of New York City, or want to be among the high rises in Canary Wharf, London, or overlooking the Millennium Park in Chicago. Now’s your time to make the step towards gaining the know-how you need to help you fully adopt DevOps in your organization.  Read more...
By 2018/09/07 | Source: Redgate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 1,934 reads

Configuring Service Broker Architecture

Learn how to configure technically reliable, consistent, robust, efficient, asynchronous message queuing and processing mechanism to start developing highly available, scalable applications based upon the service–oriented architecture.  Read more...
By Valerij Urban 2018/09/07 (first published: 2015/09/03) | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 3,899 reads

Introduction to Testing Your PowerShell Code with Pester

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.  Read more...
By Additional Articles 2018/09/06 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,330 reads

8 practices for business data security

Is your data vulnerable to security breaches? Sophie Ross at Security Gladiators provides 8 rules you should be adhering to to ensure the safety of your data.  Read more...
By 2018/09/06 | Source: Redgate | Category: data security
Rating: (not yet rated)  Rate this |   Briefcase | 2,446 reads

Creating Subtotals and Totals in Aggregated Queries

Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.  Read more...
Rating: |  Discuss |   Briefcase | 1,621 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2018/09/06 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 108,602 reads

Using MERGE in SQL Server to insert, update and delete at the same time

In a typical data warehousing application, quite often during the ETL cycle you need to perform INSERT, UPDATE and DELETE operations on a TARGET table by matching the records from the SOURCE table.  Read more...
By Additional Articles 2018/09/05 | Source: MSSQLTips.com | Category: insert
Rating: (not yet rated)  Rate this |   Briefcase | 4,775 reads

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps.  Read more...
By 2018/09/24 (first published: 2018/08/31) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 9,397 reads

Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)

Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit.  Read more...
By Hugo Kornelis 2018/09/05 (first published: 2017/01/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,290 reads

Modern Data Warehouse Design Pattern – Part I

The modern data warehouse design helps in building a hub for all types of data to initiate integrated and transformative solutions. To achieve these goals and to support modern designs, Microsoft has introduced a set of fully managed, cloud-based services that not only support modern data warehouse design patterns but also provide the advantages of inbuilt scalability, high availability, good performance, and flexibility.  Read more...
By Additional Articles 2018/09/04 | Source: Database Journal | Category: data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 3,679 reads

What SOX means to the DBA

The worry that processes in place to ensure compliance can bottleneck the development process is a very real one. So how can you have the best of both worlds? In this article Rebecca Edwards discusses the implications and possible solutions.   Read more...
By 2018/09/04 | Source: Redgate | Category: sql provision
Rating:  Rate this |   Briefcase | 2,769 reads

Create AT&T Network Hierarchy Diagrams using SQL Server Data

Diagrammatic support for large, complex hierarchical data structures in SQL Server.   Read more...
By Paul Brewer 2018/09/04 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 738 reads

Changing Linked Server Properties

A quick guide on changing the linked server properties and settings.  Read more...
By David Fundakowski 2018/09/03 (first published: 2016/07/07) | Source: SQLServerCentral.com | Category: linked servers
Rating: |  Discuss |   Briefcase | 3,697 reads

Introduction to HIPAA and SOX

Despite the attention to data privacy and protection caused this year because of the GDPR, regulations governing how data is handled are nothing new. In this article, Robert Sheldon provides an overview of two US regulations, HIPAA and SOX, and explains how these regulations affect DBAs.  Read more...
By Additional Articles 2018/09/03 | Source: SimpleTalk | Category: hipaa
Rating: (not yet rated)  Rate this |   Briefcase | 2,486 reads

SQL in the City Streamed: September 5 2018

Our all-star speaker line-up of Microsoft MVPs and Redgate team members will be running sessions on the theme ‘Adapt and thrive as a data professional’.  Read more...
By 2018/09/03 (first published: 2018/08/21) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 6,133 reads

A Presenter’s Guide to the Stack Overflow Database

Brent shows you how the table joins work and points out some neat data distribution issues.  Read more...
By Additional Articles 2018/08/31 | Source: Brent Ozar Unlimited Blog | Category: stack
Rating: (not yet rated)  Rate this |   Briefcase | 2,655 reads

How to execute an SSIS package from the command line or a batch file

An SSIS package that is executed on an ad hoc basis can be run from Business Intelligence Development Studio easily enough, but a package that is going to be run on a regular schedule is best executed through a batch file using the DTExec.exe command line utility.  Read more...
By Stan Kulp 2018/08/31 (first published: 2016/03/14) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 4,317 reads