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,890 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 | 2,081 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,970 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,738 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,596 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,777 reads

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.  Read more...
By Press Release 2019/01/23 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 119,489 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,933 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 | 10,769 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,371 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,787 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,956 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 | 763 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,769 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,605 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,254 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,746 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,442 reads