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/11/05 to 2013/11/12

SQL in the City Seminar Portland 2013 –Deployment Stairway

Join Red Gate for a free seminar on November 15 (the day before SQL Saturday Oregon). Steve Jones and Grant Fritchey, SQL Server MVPs, will present best practices for SQL Server version control, continuous integration and deployment, in addition to showing Red Gate tools in action.   Read more...
By Press Release 2013/11/12 (first published: 2013/10/31) | Source: SQL in the City | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 2,529 reads

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.   Read more...
By Patrick Cahill 2013/11/12 | Source: SQLServerCentral.com | Category: outer joins
Rating: |  Discuss |   Briefcase | 11,278 reads

Using the SQL Server Distributed Replay feature

This tip will guide you through a simple example to illustrate how you can use the SQL Server Distributed Replay feature to replay a simple SQL Server trace file that contained two sessions executing statements concurrently.  Read more...
By Additional Articles 2013/11/12 | Source: MSSQLTips.com | Category: distributed replay
Rating: (not yet rated)  Rate this |   Briefcase | 1,708 reads

Turbocharge Your Database Maintenance With Service Broker: Part 2

I demonstrate how to monitor and troubleshoot Service-Broker-task execution in the context of a database-maintenance process.  Read more...
By Marios Philippopoulos 2013/11/11 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 3,834 reads

New SQL Monitor Metric: Principals with Sysadmin Login

This metric counts the number of principals who are members of the sysadmin fixed server role. SQL Server relies on role-based security to manage permissions. If multiple IT system administrators have permissions to set up new SQL Server logins, they might be inclined to do so as part of the sysadmin role. Adding a normal user to the sysadmin role could pose a security risk and is not recommended unless the principal is highly trusted.  Read more...
By Press Release 2013/11/11 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,861 reads

The PoSh DBA – Getting Airborne with PowerShell

Maybe the best way of helping the busy database professional to get started with practical PowerShell-based administration is to pull together all the essential community cmdlets into a toolkit for the POSH DBA, and explain how and why you'd use them.  Read more...
By Additional Articles 2013/11/11 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,784 reads

SQL Server SQLCMD Basics

Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line utility is valuable to any database developer or DBA as the prime means of executing batches of SQL Statements to SQL servers, and saving results to file. Rob Sheldon gives you the basic facts about this great utility.  Read more...
By Additional Articles 2013/11/08 | Source: SimpleTalk | Category: cmd
Rating:  Rate this |   Briefcase | 5,870 reads

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.  Read more...
By Brian Kelley 2013/11/08 (first published: 2009/03/09) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 32,731 reads

SSIS Distributed Transactions

This article shows the steps to set-up distributed transactions for SSIS.  Read more...
By Brian Ellul 2013/11/07 | Source: SQLServerCentral.com | Category: dtc
Rating: |  Discuss |   Briefcase | 3,990 reads

Building Real-World Microsoft BI Dashboards Today

There is a lot of Microsoft buzz about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real-world requirements today. In this article, Jen Underwood shares what technologies were used to develop a dashboard solution for a Fortune Global 500 company using Microsoft Business Intelligence technologies, and why. Some of the decisions may surprise you and the lessons learned are sure to be of value.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,156 reads

Getting Started with Columnstored Index in SQL Server 2014 – Part 2

Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of the earlier limitations. In this article, Arshad Ali discusses how you can get started using the enhanced columnstore index feature in SQL Server 2014 and do some performance tests.  Read more...
By Additional Articles 2013/11/06 | Source: Database Journal | Category: columnstore index
Rating: (not yet rated)  Rate this |   Briefcase | 3,880 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 2014/04/02 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 19,560 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,906 reads

How to Design, Build and Test a Dynamic Search Stored Procedure

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.  Read more...
By Dwain Camps 2013/11/05 | Source: SQLServerCentral.com | Category: sql catch all query
Rating: |  Discuss |   Briefcase | 10,454 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to CU14 for SP1 and CU12 for SP2.  Read more...
By Steve Jones 2013/11/05 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 49,772 reads

Different Ways to Restore a SQL Server Database

This article describes the SQL Server database restore principles for full backups, differential backups and transaction log backups and how to perform the restores to get to a particular point in time. This tip describes SQL Server database restore principles on a database that is using the FULL recovery model.   Read more...
By Additional Articles 2013/11/05 | Source: MSSQLTips.com | Category: backup/restore
Rating: (not yet rated)  Rate this |   Briefcase | 4,915 reads