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

How do you develop and deploy your database?

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.  Read more...
By Press Release 2015/02/26 (first published: 2015/02/05) | Source: Red-Gate | Category: deployment process
Rating: (not yet rated)  Rate this |   Briefcase | 14,021 reads

Stairway To SQL Server Columnstore Indexes Level 1: A First Look At Columnstore Indexes

This level introduces of you to the fundamentals of columnstore indexes, introdused in SQL Server 2012 to manage the indexing of very large tables.  Read more...
By Hugo Kornelis 2015/02/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,965 reads

Small Leadership

Today Steve Jones talks leadership, and the value it can bring to your team if you display just a little of it.  Read more...
By Steve Jones 2015/02/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 112 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2015/02/25 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 52,741 reads

The DRI Subject of References

A database must be able to maintain and enforce the business rules and relationships in data in order to maintain the data model. It does this through referential constraints. They aren't complex, but are powerful, especially with the means to attach DRI actions to them. Joe Celko explains all, and pines for the ANSI CREATE ASSERTION statement.  Read more...
By Additional Articles 2015/02/25 | Source: SimpleTalk | Category: dri
Rating:  Rate this |   Briefcase | 5,982 reads

Error handling with try-catch-finally in PowerShell for SQL Server

PowerShell V2 introduces the "try-catch-finally" statements, similar to those you already use when you write .NET code. "Try-catch-finally" encloses a block of script that is likely to produce errors under specific circumstances and therefore helps you to keep your code organized. This article is a short usage guide for this error handling construct.   Read more...
By Additional Articles 2015/02/24 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 5,714 reads

Making Plans

PASS President Tom Larock doesn't make long term plans. Steve Jones doesn't make long term plans. Do you?  Read more...
By Steve Jones 2015/02/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 92 reads

Dynamically Query a 100 Million Row Table-Efficiently

This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.  Read more...
By Gary Strange 2015/02/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,589 reads

Microsoft and Minecraft and Training Kids

Today we have a guest editorial from Andy Warren, looking at learning.   Read more...
By Andy Warren 2015/02/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 129 reads

Collect Data from Multiple Instances Using SSIS and Powershell

Use SSIS to pull data from multiple instances. Combine with powershell to run multiple instances simultaneously.  Read more...
By S. Kusen 2015/02/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 3,885 reads

SQL Server 2014 Build List

A list of builds for SQL Server 2014, through CU5 for RTM.  Read more...
By Steve Jones 2015/02/23 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 2,356 reads

The Importance of Caching

Performance tuning and optimization definitely have their place in minimizing SQL Server Licensing costs – by helping keep CPU utilization low. But it’s important to remember that the fastest and most efficient query possible is the one that you never execute against your SQL Server. That might sound trite, but it’s at the heart of caching – which is key to helping organizations save significant money on SQL Server licensing costs while simultaneously enabling better application performance and increased scalability.  Read more...
By Additional Articles 2015/02/23 | Source: SimpleTalk | Category: caching
Rating:  Rate this |   Briefcase | 6,320 reads

The Query Store

This week Steve Jones talks about the query store after an article was released describing it.  Read more...
By Steve Jones 2015/02/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Who Truncated That Table and What Do I Do Now?

This article describes a way to identify the user who truncated the table & how you can recover the data.  Read more...
By Sujeet Singh 2015/02/20 (first published: 2014/06/05) | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 23,846 reads

The Promise - and the Pitfalls - of In-Memory OLTP

When SQL Server 2014 was released, it included Hekaton, Microsoft’s much talked about memory-optimized engine that brings In-Memory OLTP into play. With memory-optimized tables 30 times faster than disk-based tables, higher performance is promised – but at what cost? Jonathan Watts looks at the features that have improved, and those that need careful consideration.  Read more...
By Additional Articles 2015/02/20 | Source: SimpleTalk | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 8,193 reads

Where Do You End Up as a DBA?

Steve Jones talks about careers, and where you might take your career over time.  Read more...
By Steve Jones 2015/02/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 240 reads

Your Tools

In many occupations, workers invest in their own tools. However we rarely do that in technology.   Read more...
By Steve Jones 2015/02/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 202 reads

Creating Striped Backups

Learn how you can easily spread your backup across multiple files.  Read more...
By Steve Jones 2015/02/19 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 3,291 reads

Code Comparison for SQL Server vs. MariaDB

Daniel Calbimonte has written a code comparison for MariaDB vs. SQL Server as it pertains to how to comment, how to create functions and procedures with parameters, how to store query results in a text file, how to show the top n rows in a query, how to use loops, and more.  Read more...
By Additional Articles 2015/02/19 | Source: MSSQLTips.com | Category: mariadb
Rating:  Rate this |   Briefcase | 9,765 reads

DBA Skills: Striped Backup Video

Watch this short video on creating a striped backup for your database.  Read more...
By Steve Jones 2015/02/18 | Source: SQLServerCentral.com | Category: dba skills
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads
<< Newer    Items 21 to 40 of 13530    Older >>