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

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,791 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,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 | 101 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 | 5,968 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,685 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 | 7,864 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 | 226 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 | 194 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,254 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,618 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 | 39 reads

DBA Skills - Creating a Striped Backup

Learn how to create a striped backup in this short piece.  Read more...
By Steve Jones 2015/02/18 | Source: SQLServerCentral.com | Category: dba skills
Rating: |  Discuss |   Briefcase | 455 reads

SSIS Catalog Environments– Step 20 of the Stairway to Integration Services

In this next level of the Stairway to Integration Services, we look at the SSIS catalog environments and how they help you manage your package parameters.  Read more...
By Andy Leonard 2015/02/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,755 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/02/18 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 58,658 reads

Application Containers For Cloud Computing

Containers promise to make applications more portable and efficient. The technology, originally based on Linux's cgroups, provides a way of running several applications as modular, platform-agnostic packages in isolation on the same server. Docker's open-source approach to containers has dominated the market, and Microsoft is producing its own equivalent Windows system. What next? Will Containers replace VMS? Robert Sheldon investigates.  Read more...
By Additional Articles 2015/02/18 | Source: SimpleTalk | Category: containers
Rating: (not yet rated)  Rate this |   Briefcase | 7,168 reads

Byte Me: Bug Out

The right tools for the job.  Read more...
By Bob Lang 2015/02/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 326 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 5,206 reads

Automate SQL Server Express Backups and Purge Old Backups

SQL Server Express Edition does not include SQL Server Agent in order to schedule the SQL Server database backups. Here's how to automate the backups for SQL Server Express Edition and make sure the old backup files are deleted.  Read more...
By Additional Articles 2015/02/17 | Source: MSSQLTips.com | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 9,219 reads

SQL Monitor Custom Metric: Tempdb Allocation Contention

If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Tempdb is shared by all databases and is used for many operations in a SQL Server instance, so it is common for tempdb to cause performance problems.  Read more...
By Additional Articles 2015/02/17 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,923 reads

SQL Injection, Still?

We still have problems with SQL Injection. Steve Jones has a few thoughts on why.  Read more...
By Steve Jones 2015/02/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 182 reads
<< Newer    Items 21 to 40 of 13521    Older >>