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

<< Newer    Items 61 to 80 of 13868    Older >>
 

Powershell day-to-day Admin tasks: WMI, CIM and PSWA

WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.  Read more...
By Additional Articles 2015/06/15 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,461 reads

Stored Procedures and SQL Injection

Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.  Read more...
By Brian Kelley 2015/06/12 (first published: 2013/02/18) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 19,461 reads

Managing Test Data as a Database CI Component - Part 2

Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.  Read more...
By Additional Articles 2015/06/12 | Source: SimpleTalk | Category: continuous integration
Rating: (not yet rated)  Rate this |   Briefcase | 2,351 reads

The Rename Game

How often do you rename things? It seems to be more common for some than others.  Read more...
By Steve Jones 2015/06/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Checking Table Metadata with tSQLt

In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.  Read more...
By Steve Jones 2015/06/11 | Source: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 4,174 reads

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.  Read more...
By Additional Articles 2015/06/11 | Source: Database Journal | Category: pivot
Rating:  Rate this |   Briefcase | 4,433 reads

Practical Hekaton

Steve Jones is searching for anyone that is using In-Memory OLTP tables in production.  Read more...
By Steve Jones 2015/06/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 129 reads

Stairway To Columnstore Indexes Level 3: Building The Columnstore

The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.  Read more...
By Hugo Kornelis 2015/06/10 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,595 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2015/06/10 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 42,106 reads

Byte Me: Hard Copy

Stack overflow.  Read more...
By Bob Lang 2015/06/10 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 375 reads

Reusing T-SQL Code

Alex Kuznetsov, in an article taken from his book 'Defensive Database Programming with SQL Server', shows how DRY principles can be put in practice with constraints, stored procedures, triggers, UDFs and indexes.  Read more...
By Additional Articles 2015/06/10 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,118 reads

SELECT INTO vs INSERT INTO on Columnstore

This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.  Read more...
By Ramya Makam 2015/06/09 | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 13,307 reads

Archive Every Day

There are challenges with the large scale archiving of data. Steve Jones talks about rethinking this as a daily process rather than a periodic one.  Read more...
By Steve Jones 2015/06/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

Protecting Yourself from SQL Injection in SQL Server - Part 2

Aaron Bertrand has some advice on how to protect yourself from SQL Injection, looking at some specific common scenarios.   Read more...
By Additional Articles 2015/06/09 | Source: MSSQLTips.com | Category: sql injection
Rating: (not yet rated)  Rate this |   Briefcase | 4,310 reads

SQL Monitor Custom Metric: WriteLog wait time

This metric shows Writelog wait time in ms, per elapsed second. Writelog wait types occur when the log cache is being flushed to disk. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.  Read more...
By Press Release 2015/06/09 | Source: SQLServerCentral.com | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,927 reads

When Should We Be Cleaning Data?

Part of our job as a data professional often deals with the movement and cleaning of data. However, should we be trying to reduce the work we do? Move the burden to the application? Steve Jones has a few comments.  Read more...
By Steve Jones 2015/06/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 159 reads

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.  Read more...
By Gail Shaw 2015/06/08 | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 9,709 reads

The Multi-skilled Developer

Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.  Read more...
By Phil Factor 2015/06/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 187 reads

How to Get SQL Server Dates and Times Horribly Wrong

One of the times that you need things to go right is when you are doing analysis and reporting. This is generally based on time and date. A sure-fire way of getting managers upset is to get the figures horribly wrong by messing up the way that you handle datetime values in SQL Server. In the interests of peace, harmony and a long career in BI, Robert Sheldon outlines some of the worst mistakes you can make when using SQL Server dates.  Read more...
By Additional Articles 2015/06/08 | Source: SimpleTalk | Category: dates
Rating:  Rate this |   Briefcase | 5,901 reads

Demystifying the use of CASE in an ORDER BY statement

Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.  Read more...
By Chuck Hoffman 2015/06/05 (first published: 2012/04/26) | Source: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 24,928 reads
<< Newer    Items 61 to 80 of 13868    Older >>