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

<< Newer    Items 21 to 40 of 13767    Older >>
 

Database Continuous Integration Workshop - London, UK

Join this workshop on July 8, 2015 to learn how to: link your source control repository to a build system, trigger database builds automatically when you make a change, use DLM tools to test your database changes, and lay the foundations for package-based deployment of your database. Register while space is available.  Read more...
By Press Release 2015/05/22 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,547 reads

Interactive Parameter Selection with Reporting Services

Revamp the classic Reporting Services interface with a more modern look and feel adapted to mobile BI  Read more...
By Adam Aspin 2015/05/21 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 5,277 reads

Naming Confusion

The naming of systems and other technological constructs is always a debate within groups. Steve Jones points out a few places where this might actually prevent mistakes.  Read more...
By Steve Jones 2015/05/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 108 reads

Webinar: How to safely manage application and database changes with continuous delivery

Join Brian A. Randell, Grant Fritchey and Steve Jones in this panel discussion to hear tips, ideas and share your questions on managing application and database deployments with continuous delivery. This Free webinar will be on May 27th at 4PM BST, register while space is available.  Read more...
By Press Release 2015/05/26 (first published: 2015/05/21) | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 7,430 reads

PCI Best Practices Guide for SQL Server DBAs

Tibor Nagy has put together some best practices to help SQL Server DBAs navigate the many different requirements around PCI compliance.  Read more...
By Additional Articles 2015/05/21 | Source: MSSQLTips.com | Category: best practices
Rating: (not yet rated)  Rate this |   Briefcase | 4,674 reads

Building the Ideal VMware-based SQL Server Virtual Machine - Level 3 of the Stairway to SQL Server Virtualization

In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware.  Read more...
By David Klee 2015/05/20 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 5,391 reads

Controlling Alerts

Being on call is not much fun for anyone, but it can certainly be hard on those that receive lots of calls for systemic issues. Are there better ways to manage this?  Read more...
By Steve Jones 2015/05/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 reads

Free Guide: Eight Steps to Effective SQL Server Monitoring

This free guide includes worked examples, practical advice, and covers the hows and why of SQL Server monitoring. Download the guide and get a 26 monitoring tips as well.  Read more...
By Press Release 2015/05/20 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 7,741 reads

DevOps and the DBA

Michael Fal is a huge advocate of automation and many ways it can improve the lives of developers and DBAs alike, but you can’t just automate all your problems away. The real challenge is breaking down barriers and having developers and DBAs functioning smoothly together. You may have heard of DevOps, and so Mike explores what the buzz might mean for database administrators.  Read more...
By Additional Articles 2015/05/20 | Source: SimpleTalk | Category: devops
Rating:  Rate this |   Briefcase | 5,238 reads

VMs are not VMs

Today Steve Jones talks about how database VMs are not like other VMs.  Read more...
By Steve Jones 2015/05/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 177 reads

A Complex Database Project in Visual Studio SSDT

One Way to Handle a Very Complex Database Project with Several Databases and Cross References  Read more...
By Hakim Ali 2015/05/19 | Source: SQLServerCentral.com | Category: ssdt
Rating: |  Discuss |   Briefcase | 6,140 reads

Database Source Control Workshop - London, UK

Redgate's workshops are coming to London on July 8, 2015. In this workshop, you'll learn how to source control your database, deploy your databases from source control, and monitor and track database changes across development, testing, and production environments. Register while space is available.  Read more...
By Press Release 2015/05/19 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,914 reads

Testing SQL Server Backup Performance with Trace Flag 3042

Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.  Read more...
By Additional Articles 2015/05/19 | Source: MSSQLTips.com | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 4,396 reads

Boring or Scripting

There is no shortage of mundane tasks at work. Steve Jones notes that you might not want to depend on those to fill your day in the future.  Read more...
By Steve Jones 2015/05/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 200 reads

Testing Simple Calculations and UDFs with tSQLt

This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.  Read more...
By Steve Jones 2015/05/18 | Source: SQLServerCentral.com | Category: tsqlt
Rating: |  Discuss |   Briefcase | 3,907 reads

Awareness

This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.  Read more...
By Steve Jones 2015/05/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

SQL Saturday #407 - Vancouver

SQL Saturday is coming to Vancouver, British Columbia on June 27 2015. Join us for a free day of SQL Server training and networking. Register while space is available.  Read more...
By Press Release 2015/05/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,112 reads

Documenting your SQL Server Database

One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javadocs or Doxygen provides. To embed the documentation in the source is so obvious and easy that it is a wrench to be without this facility. Phil Factor suggests a solution.   Read more...
By Additional Articles 2015/05/18 | Source: SimpleTalk | Category: documentation
Rating: (not yet rated)  Rate this |   Briefcase | 6,807 reads

Usage of CTE - Trick with Dates

This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.  Read more...
By Suresh Maganti 2015/05/15 (first published: 2013/06/18) | Source: SQLServerCentral.com | Category: cursor vs recursive cte
Rating: |  Discuss |   Briefcase | 28,849 reads

Searching for Plans

Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.  Read more...
By Steve Jones 2015/05/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 223 reads
<< Newer    Items 21 to 40 of 13767    Older >>