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

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

How to partition data in Tabular SSAS

Partitioning data is a standard SQL Server administration practice. Partitions enable independent administration of different slices of data. When a SQL Server Analysis Services (SSAS) tabular data model is developed and processed, data is read from the source system and loaded into the tabular data model configured in In-Memory processing mode. Every time the model is processed, the entire data set may not require re-processing. Only certain slices of data containing changes may require re-processing which can be achieved by partitioning data into logical slices. In this post, Siddharth Mehta looks at how to partition tables in Tabular SSAS.  Read more...
By Additional Articles 2017/06/08 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,480 reads

Webinar: Microsoft’s Agile Transformation Story

Learn how Microsoft adopted DevOps at scale in this free Redgate webinar on June 12. Donovan Brown, Senior DevOps Program Manager in Microsoft’s US Developer Division, will share how Microsoft embarked on its own DevOps journey reducing a three-year release cycle down to three weeks. Sign up now.  Read more...
By 2017/06/08 (first published: 2017/05/30) | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 11,138 reads

Byte Me: Diagnosis Data

By Bob Lang 2017/06/07 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 68 reads

Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.  Read more...
By Hugo Kornelis 2017/06/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 731 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2017/06/07 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 79,920 reads

Comparing SSIS Catalog Contents Using DBFit Framework

When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have to check to make sure that the deployment will be successful. These will include such settings as the values in environment variables, Package parameters and project parameters. The DbFit test framework turns out to be ideal for the purpose of doing final checks as part of a deployment process, as Nat Sundar demonstrates.  Read more...
By Additional Articles 2017/06/07 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,521 reads

The OUTPUT Clause for UPDATE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause in capturing the results of the updated rows into a table variable for the UPDATE statements.   Read more...
By Amarendra Reddy Thummeti 2017/06/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,883 reads

The Poor State of Secure Coding

The way we code isn't necessarily getting better. 
By Steve Jones 2017/06/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

SQL Server Temporary Object Caching

Paul White describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.  Read more...
By Additional Articles 2017/06/06 | Source: SQLPerformance.com | Category: temporary objects
Rating: (not yet rated)  Rate this |   Briefcase | 3,277 reads

How to style your SQL using SQL Prompt’s new formatting options

Prefer tabs but your teammates use spaces? That's not a problem with the brand new formatting options in SQL Prompt. It's now possible to customize, save, and share multiple styles that you can then quickly switch between when working. Here's how it works, and how to get set up.  Read more...
By Additional Articles 2017/06/06 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 3,461 reads

Practical usage of SQLCLR: Building QueryToHtml function

This article shows a few techniques with SQLCLR to to transform a query result into HTML.   Read more...
By Darko Martinovic 2017/06/05 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,371 reads

Big Power Issues

The British Airways IT disaster showcases some poor technology architecture.  Read more...
By Steve Jones 2017/06/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

Where is my SQL Server Configuration Manager?

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,935 reads

Simplifying the user access audit with SQL Census

SQL Census is the latest piece of technology to be developed within Redgate Foundry. Still early in its development, it’s a product that’s designed to help you explain to an auditor which of your colleagues are able to access business-critical SQL Server databases. Here's how it works, and how you can get involved with the early access program.  Read more...
By 2017/06/05 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,435 reads

Presentations that are Easy on the Eyes

Today Steve Jones talks presentations, specifically the best way to share information on a projector.  Read more...
By Steve Jones 2017/06/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.  Read more...
By Mickey Stuewe 2017/06/02 (first published: 2016/01/04) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,178 reads

Free ebook: Stairway to SQL Server XML

Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML.  Read more...
By Additional Articles 2017/06/02 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 4,525 reads

Introducing DLM Techniques for a Multi-Database Multi-Server System

Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems, what if the database 'layer' consists of several large interdependent databases and data flows with replication and audit? Does DLM scale to this level of complexity? Margaret Cruise O'Brien starts a series of articles that describes the practicalities of improving DLM within an existing framework and team supporting a multi-database multi-server system, by describing some of the database management problems and solutions in an enterprise-scale database.  Read more...
Rating:  Rate this |   Briefcase | 2,369 reads

Database DevOps Training

This is aimed at anyone responsible for SQL Server schema changes. The course teaches how to manage database changes throughout their lifecycle, helping to deliver more frequently and more reliably. London, September 25 - 27 2017.  Read more...
By 2017/06/02 | Category: training
Rating: (not yet rated)  Rate this |   Briefcase | 2,689 reads
<< Newer    Items 61 to 80 of 15854    Older >>