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

<< Newer    Items 41 to 60 of 13855    Older >>
 

Data Mining Part 29: Programming with C# and AMO

In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.  Read more...
By Daniel Calbimonte 2015/06/16 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 1,945 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/16 | Source: Database Journal | Category: pivot
Rating:  Rate this |   Briefcase | 3,596 reads

More Regulation Coming?

With no end to company hack attacks in sight, will we get new regulation instead?  Read more...
By Steve Jones 2015/06/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 184 reads

How do you use change scripts for your database deployments?

Redgate is researching how people deploy their database changes. This is a very quick survey, and there's an opportunity to sign up for a research call in exchange for a $50 Amazon voucher.  Read more...
By Press Release 2015/06/16 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,376 reads

Five Minute Refactoring

The debate over how to change code or solve a problem can create arguments that last for years. Steve Jones notes the idea of limiting debates to five minutes is interesting.  Read more...
By Steve Jones 2015/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 149 reads

The Challenges of Space

CSS Engineers at Microsoft are reporting more space issues with database systems. Steve Jones has a few comments.  Read more...
By Steve Jones 2015/06/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 107 reads

Cellular Automation – SQL Server CPU, IO and Hekaton Stress Testing

This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.  Read more...
By Paul Brewer 2015/06/15 | Source: SQLServerCentral.com | Category: spatial
Rating: |  Discuss |   Briefcase | 2,889 reads

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,444 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,380 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,340 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 | 109 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,133 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 | 126 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,409 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,556 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,087 reads

Byte Me: Hard Copy

Stack overflow.  Read more...
By Bob Lang 2015/06/10 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 368 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,075 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,214 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 | 101 reads
<< Newer    Items 41 to 60 of 13855    Older >>