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

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 | 164 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 | 5,987 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,472 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,032 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 | 187 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,838 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,735 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

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,375 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,612 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 | 218 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,572 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,824 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,335 reads

T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements

Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.  Read more...
By Additional Articles 2015/05/14 | Source: Database Journal | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 8,680 reads

SQL Saturday #379 - South Florida

Join us for a free day of SQL Server training and networking in Davie, Florida on June 13, 2015. Admittance to this event is free, so register while space is available.  Read more...
By Press Release 2015/05/14 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,610 reads

Byte Me: The Nectar of Life

Whatever gets you through the day.  Read more...
By Bob Lang 2015/05/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 609 reads

The Ideal SQL Server Virtual Machine Architecture - Level 2 of the Stairway to SQL Server Virtualization

In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.  Read more...
By David Klee 2015/05/13 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 8,036 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2015/05/13 | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 6,566 reads
<< Newer    Items 21 to 40 of 13758    Older >>