Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

   Items 1 to 20 of 13677    Older >>
 

Dig Out the Root Cause

Finding the basis for a problem is always the best solution.  Read more...
By Steve Jones 2015/04/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 50 reads

Comprehensive Baseline Collector Solution (Updated)

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution  Read more...
By Robert Virag 2015/04/28 (first published: 2014/10/21) | Source: SQLServerCentral.com | Category: baseline
Rating: |  Discuss |   Briefcase | 6,381 reads

Mobile BI with SQL Server Reporting Services

For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device. Adam Aspin demonstrates some of the ways that we can deliver easy-to-use Business Intelligence to tablets and smartphones using Reporting Services.  Read more...
By Additional Articles 2015/04/28 | Source: SimpleTalk | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 2,347 reads

Survey on SQL Server Monitoring

If looking after the health of SQL Server is part of your responsibility, Redgate would love to hear your views on monitoring server health through this 10 minute survey. Complete the survey by May 15th to be in with the chance to win one of three $50 Amazon vouchers.  Read more...
By Press Release 2015/04/28 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,898 reads

Microsoft Exercise

We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.  Read more...
By Steve Jones 2015/04/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 90 reads

Data Mining Part 27: Microsoft Data Mining with Cubes

In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.  Read more...
By Daniel Calbimonte 2015/04/27 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 2,093 reads

Email In The Bathroom: Not A Universal Good

Here are some fine, affordable products to completely destroy your work-life balance.  Read more...
By Dave Convery 2015/04/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

Time Testing SQL Azure Point In Time Database Restores

If you need to do a time test for restoring an Azure SQL database from a point in time, and wonder about automating this through PowerShell, here are the guidelines that Tim Smith would you recommend?  Read more...
By Additional Articles 2015/04/27 | Source: MSSQLTips.com | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,877 reads

Learn Continuous Integration for Databases in Bellevue, WA

Redgate Software has teamed up with Northwest Cadence to present a workshop on May 15, 2015. Come learn how to implement continuous integration in your database development software pipeline.  Read more...
By Press Release 2015/04/27 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,977 reads

Code Reviews

This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.  Read more...
By Steve Jones 2015/04/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

How to Recover a SQL Server Login Password

I will describe a simple method anyone can use to obtain lost password information for a SQL Server login.  Read more...
By Geoff Albin 2015/04/24 (first published: 2013/03/04) | Source: SQLServerCentral.com | Category: password cracking
Rating: |  Discuss |   Briefcase | 28,263 reads

Understanding Cross-Database Transactions in SQL Server

Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit.  Read more...
By Additional Articles 2015/04/24 | Source: SimpleTalk | Category: distributed transactions
Rating: (not yet rated)  Rate this |   Briefcase | 4,051 reads

Your Role Is Changing

The DBA role is changing with the growth of DevOps as a way to better build software in an organization.  Read more...
By Sjors Takes 2015/04/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Adding Slicers to a Reporting Services Report

This article shows you how to create dynamic slicers from a data set in an SSRS report  Read more...
By Adam Aspin 2015/04/23 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 7,253 reads

Continue a Foreach loop after an error in a SQL Server Integration Services package

Say you have a SQL Server Integration Services (SSIS) package with a Foreach Loop container. Inside that container you have a task that sometimes can fail. Koen Verbeeck provides a tip on how to implement SSIS so that, if it fails, the loop will just continue, skip the current step and go to the next iteration.  Read more...
By Additional Articles 2015/04/23 | Source: MSSQLTips.com | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 3,698 reads

Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery

Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery.   Read more...
By Press Release 2015/04/23 (first published: 2015/04/17) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,965 reads

Stairway to SQL PowerShell Level 9: Objects For Everyone

This level will show how to create objects including a login, a database, a filegroup, a file a database user and then we’ll end with a table and an index.  Read more...
By Ben Miller 2015/04/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,819 reads

Security Through Chaos

A company Steve Jones knows uses a diverse network infrastructure to help provide security.  Read more...
By Steve Jones 2015/04/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Schema-Based Access Control for SQL Server Databases

Access-control within the database is important for the security of data, but it should be simple to implement. It is easy to become overwhelmed by the jargon of principals, securables, owners, schemas, roles, users and permissions, but beneath the apparent complexity, there is a schema-based system that, in combination with database roles and ownership-chaining, provides a relatively simple working solution.  Read more...
By Additional Articles 2015/04/22 | Source: SimpleTalk | Category: access restriction
Rating: (not yet rated)  Rate this |   Briefcase | 4,350 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 2015/04/22 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 60,505 reads
   Items 1 to 20 of 13677    Older >>