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 13763    Older >>
 

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,403 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,266 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 | 77 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,305 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,059 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 | 169 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,051 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,634 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,166 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 | 192 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,855 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 | 51 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 | 3,900 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,567 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,706 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 | 219 reads

Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow

If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.  Read more...
By Additional Articles 2015/05/15 | Source: ITKnowledge Exchange | Category: automation
Rating:  Rate this |   Briefcase | 5,621 reads

Automated Database Deployment Workshop: Belfast, Northern Ireland

Redgate's DLM Workshops are coming to Belfast, NI on June 26, 2015. Learn how to: deploy databases using Redgate's DLM tools, assess the different requirements of production and non-production deployments, and handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.  Read more...
By Press Release 2015/05/15 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,873 reads

Documenting with Tests

The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.  Read more...
By Steve Jones 2015/05/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

Column Store vs Row Store Indexes

How does a column store index compare to a (traditional)row store index with regards to performance  Read more...
By Brian Ellul 2015/05/14 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 6,412 reads
<< Newer    Items 21 to 40 of 13763    Older >>