Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/03/18 to 2013/03/25

Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks

You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.  Read more...
By Ben Miller 2013/03/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,556 reads

Data Science Laboratory System - Instrumentation

It is sensible to check the performance of different solutions to data analysis in 'lab' conditions. Measurement by instrumentation makes it easier to develop systems that are efficient.  Read more...
By Additional Articles 2013/03/25 | Source: SimpleTalk | Category: data science
Rating: (not yet rated)  Rate this |   Briefcase | 2,279 reads

Creating Custom T-SQL Conditions and Policies for SQL Server Policy-Based Management

In SQL Server, the built in conditions and policies are a great place to get started with monitoring your environment, but there are no facets for some aspects of SQL Server I want to monitor. How can I check on my environment using Policy Based Management? Check out this tip to learn more.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,738 reads

Use of Identity Property to Resolve Concurrency Issues

This article describes how the identity property was used to resolve contention in a database  Read more...
By Ajit Ananthram 2013/03/22 (first published: 2011/02/24) | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 17,700 reads

Red Gate brings SQL in the City back to London for the third year running

Data professionals are invited to attend Red Gate’s free SQL in the City event for a day of SQL Server training in London.  Read more...
By Press Release 2013/03/26 (first published: 2013/03/21) | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 640 reads

SQLServerCentral Runs sp_Blitz - Performance Part 2

The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.  Read more...
By Steve Jones 2013/03/21 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 6,209 reads

Query Tuning, Encryption, and more at SQL Intersection

Grant Fritchey is speaking about query tuning, Steve Jones talking about Encryption, Paul Randal telling you how to make SQL Server faster. All at SQL Intersection. Join us in April.  Read more...
By Press Release 2013/03/21 | Source: SQLServerCentral.com | Category: sql intersection
Rating: (not yet rated)  Rate this |   Briefcase | 3,365 reads

Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment

SQL Server's Query optimiser judges the best query plan from the data in the relevant tables and the server's hardware. How, then, can you investigate the query plans being generated for slow-running queries on a customer's production server when you can neither access the server, nor recreate the database from a backup?  Read more...
By Additional Articles 2013/03/21 | Source: SimpleTalk | Category: optimizer_whatif
Rating:  Rate this |   Briefcase | 1,953 reads

The Power of the SQL Server Database Owner

I have a couple of databases supporting applications. The first application requires that it's user be a member of the db_owner role. The second application actually has to own the database. What are the effects of having such permissions? Check out this tip to learn more.  Read more...
By Additional Articles 2013/03/20 | Source: MSSQLTips.com | Category: db_owner
Rating:  Rate this |   Briefcase | 3,870 reads

Populating a Vertically Filtered Replicated Table

Vertical filtering of a large replicated table introduces the potential for unwanted transactions to be pushed to the subscriber. This article talks about how you might avoid this.  Read more...
By Jason Bunn 2013/03/20 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,254 reads

Expand Your Skills at the PASS Business Analytics Conference

Join top business intelligence and analytics experts in Chicago April 10-12 for 60+ sessions on the best practices, prescriptive guidance, and strategic vision you need to get the most from your data. Use code BACSSC to save $250 today!  Read more...
By Press Release 2013/04/03 (first published: 2013/03/14) | Source: PASS | Category: bi
Rating: (not yet rated)  Rate this |   Briefcase | 6,320 reads

Accounting for Windows Azure

On Thursday March 21st 12PM noon Central, Steve Hughes will discuss Accounting for Windows Azure when looking at Data Architecture.   Read more...
By Press Release 2013/03/19 | Source: SQLServerCentral.com | Category: pass
Rating: (not yet rated)  Rate this |   Briefcase | 2,375 reads

Trigger an Email of an SSRS Report from an SSIS Package

This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.  Read more...
By Stan Kulp 2013/03/19 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 9,824 reads

Full Text Searches on Documents in FileTables

SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. The best way of learning FileTable is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.  Read more...
By Additional Articles 2013/03/19 | Source: SimpleTalk | Category: full text search
Rating:  Rate this |   Briefcase | 2,219 reads

SQLServerCentral at SQL Intersection

Steve Jones and Grant Fritchey will be speaking at the SQL Intersection conference in April. Come join them in learning about SQL Server in the spring.  Read more...
By Press Release 2013/03/18 | Source: SQLServerCentral.com | Category: sql intersection
Rating: (not yet rated)  Rate this |   Briefcase | 1,369 reads

Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function

Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.  Read more...
By Bill Pearson 2013/11/06 (first published: 2013/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,895 reads

Database Deployment Challenges

There are a number of challenges that make the deployment task more difficult. Alex reviews the common techniques for deploying new databases and upgrading existing ones, and their flaws, and argues the advantages of an automated, incremental, script-based approach to deployments.  Read more...
By Additional Articles 2013/03/18 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,550 reads