Dwain Camps Condensing a Delimited List of Integers in SQL Server In real-world applications, it often makes sense to show denormalized data such as delimited lists within the application's user interface.... 28 August 2013 16 min read
Robert Sheldon Using DAX to create SSRS reports: The Basics You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires... 27 August 2013 15 min read
Phil Factor Getting Data between Excel and SQL Server using ODBC With ODBC, you can summarise, and select just the data you need, in an Excel workbook before importing it into... 16 August 2013 28 min read
Simple Talk Editorial Team Simple-Talk Book Reviews On Simple-Talk, we like to have some book reviews. Unlike articles, we cannot pay for book reviews, but neither does... 06 August 2013 4 min read
Robert Sheldon Columnstore Indexes in SQL Server 2012 The columnstore index in SQL Server 2012 stores columns instead of rows, and is designed to speed up analytical processing... 30 July 2013 11 min read
Sebastian Meine Fundamentals of SQL Server 2012 Replication by Sebastian Meine Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book begins with a short... 26 July 2013 2 min read
Phil Factor SQL Server ALTER TABLE syntax diagrams The words in the documentation for the ALTER TABLE syntax on MSDN are accurate with forensic precision, but the potentially-useful... 09 July 2013 8 min read
Sergei Dumnov Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 1 It is possible to use the R statistical package to extract Business Intelligence from the data in a SQL Server... 08 July 2013 22 min read
Louis Davidson Baselining with SQL Server Dynamic Management Views When you're monitoring SQL Server, it is better to capture a baseline for those aspects that you're checking, such as... 02 July 2013 18 min read
Feodor Georgiev Collecting the Information in the Default Trace The default trace is still the best way of getting important information to provide a security audit of SQL Server,... 02 July 2013 14 min read
Rob Garrison Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1 The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you... 25 June 2013 12 min read
Buck Woody Data Science Laboratory System – Relational Database Management Systems There is no better way of understanding new data processing, retrieval, analysis or visualising techniques than actually trying things out... 14 June 2013 19 min read
Jonathan Allen Preparing to Upgrade your SQL Server It isn't a problem to use deprecated TSQL features until it comes to the time to move the database to... 12 June 2013 17 min read
Hugo Kornelis Painless management of a logging table in SQL Server Tables that log a record of what happens in an application can get very large, easpecially if they're growing by... 11 June 2013 26 min read
Alexander Karmanov Automating SQL Server Database Deployments: Scripting Details To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted... 06 June 2013 30 min read
Phil Factor SQL Server CREATE TABLE syntax diagrams Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough... 06 June 2013 8 min read
Andy Brown Moving Data From Excel to SQL Server – 10 Steps to Follow SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates... 21 May 2013 15 min read
Grant Fritchey The DBA Detective: The Case of the Missing Index When problems arise in SQL Server, we're faced with a server full of suspects, including disk I/O, memory, CPU, incorrect... 15 May 2013 12 min read
Allen White Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell.... 03 May 2013 15 min read
Tools Michael Sorens in Tools MySQL Compare: The Manual That Time Forgot, Part 1 Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you... 03 May 2013 14 min read
