Database Programming

Posts (453 posts published)

• Replacing Trace Flags 1204 and 1222 with the Extended Events system_health Session

  by Jes Borland on April 24, 2018
• SQL is Hard (still): Reviving a stale application

  by Eli Weinstock-Herman (tarwn) on February 6, 2018

  azure sql
• Use ostress to load test a SQL database

  by Jes Borland on October 26, 2017
• Testing SQL Server with an Application

  by Jes Borland on June 21, 2016
• Level Up Your SQL Server Index Knowledge

  by Jes Borland on June 12, 2015
• T-SQL Tuesday #67 – What Extended Events is Missing

  by Jes Borland on June 9, 2015
• You're Invited to T-SQL Tuesday #67: Extended Events

  by Jes Borland on June 2, 2015
• Split a Query Window in SSMS

  by Jes Borland on September 10, 2014
• 2013 – Review of Writing

  by Ted Krueger (onpnt) on January 2, 2014
• Document Your SQL Server Databases with Extended Properties

  by Jes Borland on November 6, 2013
• SQL Agent Job High Availability – Availability Groups

  by Ted Krueger (onpnt) on October 5, 2013
• Managing Transaction Log Growth

  by Ted Krueger (onpnt) on June 27, 2013
• SQL Server 2014 CTP1 native compiled Hekaton procedures are faster than regular procedures

  by SQLDenis on June 25, 2013

  hekaton sql server 2014
• Supported and unsupported datatypes with Hekaton tables

  by SQLDenis on June 25, 2013

  hekaton sql server 2014
• New Dynamic Management Views in SQL Server 2014 CTP1

  by SQLDenis on June 25, 2013

  dmv dynamic management view hekaton sql server 2014
• Yeah, I am sure that is the reason we have Oracle on Azure and Hyper-V now

  by SQLDenis on June 24, 2013

  azure hyper-v oracle sql server
• Nice Collection Of Free SQL Server, Visual Studio, Azure ebooks

  by SQLDenis on June 19, 2013

  ebook sql server sql server 2012
• SQL Is Hard

  by Eli Weinstock-Herman (tarwn) on June 12, 2013

  sql development learning
• SQL Puzzle.. How many uppercase and lowercase characters in a column

  by SQLDenis on June 12, 2013

  puzzle sql server 2000 sql server 2005 sql server 2008 sql server 2012 teaser
• Changing a column that is already populated into a column that uses a sequence

  by SQLDenis on June 5, 2013

  how to sequence sql server 2012
• SQL Puzzle...how many even numbers are there in a row

  by SQLDenis on May 29, 2013

  puzzle sql server 2000 sql server 2005 sql server 2008 sql server 2012 teaser
• SQL Puzzle: RIGHT without using the RIGHT function

  by SQLDenis on May 22, 2013

  puzzle sql server 2000 sql server 2005 sql server 2008 sql server 2012 teaser
• Deploying Database Changes with PowerShell

  by Eli Weinstock-Herman (tarwn) on May 17, 2013

  deployment powershell sql
• Where to find the xtype info for SQL Server in a table

  by SQLDenis on April 26, 2013

  howto sql server 2000 sql server 2005 sql server 2008 sql server 2012 table tip
• Using a Dedicated Administrator Connection via SSMS

  by SQLDenis on April 7, 2013

  dac how to sql server 2008 sql server 2012
• BCP all tables into files from a database

  by SQLDenis on March 31, 2013

  bcp bulk export bulk import data migration
• Loading Large Volumes of Data into SQL Azure with SSIS

  by Ted Krueger (onpnt) on March 22, 2013
• Trying out Amazon Relational Database Service

  by SQLDenis on March 21, 2013

  amazon web services aws cloud rds
• SQL Sentry – Providing Performance and Knowledge

  by Ted Krueger (onpnt) on March 21, 2013
• Creating a SQL Server Unique Index that behaves like an Oracle Unique Index

  by SQLDenis on March 20, 2013
• MongoDB 2.4 Released

  by SQLDenis on March 20, 2013

  bigdata mongodb nosql
• Unique index difference between Oracle and SQL Server

  by SQLDenis on March 19, 2013

  gotcha null oracle sql server tip
• Using WITH RESULT SETS with stored procedures that return multiple resultsets

  by SQLDenis on March 18, 2013

  how to sql server 2012
• Use WITH RESULT SETS to change column names and datatypes of a resultset

  by SQLDenis on March 17, 2013

  how to sql server 2012
• Wrap inserts in a transaction for faster performance

  by SQLDenis on March 13, 2013

  performance sql server 2008 sql server 2012 testing transactions
• Another solution for my caching problem with servicestack.text, dapper and sql server.

  by Christiaan Baes (chrissie1) on March 9, 2013

  cache redis servicestack.text sql server
• Use the sp_describe_undeclared_parameters stored procedure to check if dynamic SQL has undeclared parameters

  by SQLDenis on March 6, 2013
• Giving only insert permissions to a table for a new login

  by SQLDenis on March 4, 2013

  security sql server 2000 sql server 2005 sql server 2008 sql server 2012 tables
• Column name or number of supplied values does not match table definition when dealing with temp tables

  by SQLDenis on March 3, 2013

  gotcha sql server 2000 sql server 2005 sql server 2008 sql server 2012 tables temp tables
• Redis and VB.Net

  by Christiaan Baes (chrissie1) on March 3, 2013

  redis vb.net
• MongoDB: Using the web-based administrative tool

  by SQLDenis on February 24, 2013

  administration bigdata mongodb nosql tools
• Listing tables that are truly partitioned in SQL Server

  by SQLDenis on February 23, 2013

  features partitioning sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• Suppressing xp_cmdshell output

  by SQLDenis on February 21, 2013

  features sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms xp_cmdshell
• Ten things added after SQL Server 2000 that I like the most

  by SQLDenis on February 18, 2013

  sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• MongoDB: Returning documents where fields are null or not existing

  by SQLDenis on February 17, 2013

  bigdata collections mongodb nosql null
• Listing all RESTORE and BACKUP operations currently going on your SQL Server

  by SQLDenis on February 17, 2013

  backup restore sql server 2000 sql server 2005 sql server 2008 sql server 2012
• Windows and SQL Server 2012 Test Setup

  by Ted Krueger (onpnt) on February 15, 2013
• Getting the tables with the most rows from your database

  by SQLDenis on February 8, 2013

  sql server 2000 sql server 2005 sql server 2008 sql server 2012 sqlcop tables
• Getting the biggest tables in your SQL Server database

  by SQLDenis on February 8, 2013

  sql server 2000 sql server 2005 sql server 2008 sql server 2012 sqlcop tables
• MongoDB: Creating capped collections

  by SQLDenis on February 6, 2013

  bigdata collections mongodb nosql
• A couple of ways to convert an integer to an coordinate with SQL Server

  by SQLDenis on February 3, 2013

  conversion sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• MongoDB: Exporting data into files

  by SQLDenis on February 3, 2013

  bigdata collections export mongodb nosql
• Umm....No...that is not how you export a table into a file with SQL Server

  by SQLDenis on January 31, 2013

  export files sql server 2008 sql server 2008 r2 sql server 2012
• Why there should be SQL Content at Techdays.be

  by Axel Achten (axel8s) on January 29, 2013
• MongoDB: How to include and exclude the fields you want in results

  by SQLDenis on January 25, 2013

  bigdata filtering mongodb nosql sorting
• WHERE not to use FUNCTIONS

  by Axel Achten (axel8s) on January 24, 2013

  function sql server tsql where
• Script to Populate Date Dimension, without Using a Cursor

  by Sam Vanga on January 22, 2013

  data warehouse
• Why avoiding multiple code blocks in a Stored Procedure

  by Axel Achten (axel8s) on January 21, 2013

  case if else procedure cache t-sql
• Multidocument updates with MongoDB

  by SQLDenis on January 20, 2013

  bigdata mongodb nosql update
• Import Wizard – Microsoft.ACE.OLEDB 12.0 provider is not registered

  by Ted Krueger (onpnt) on January 19, 2013
• Indexes in MongoDB: A quick overview

  by SQLDenis on January 19, 2013

  bigdata indexes indexing mongodb nosql
• Displaying missing dates by utilizing a calendar table

  by SQLDenis on January 17, 2013

  calendar dates left join
• Does anyone use the NTILE() windowing function?

  by SQLDenis on January 16, 2013

  ntile ranking windowing functions
• MongoDB, how to sort results

  by SQLDenis on January 16, 2013

  bigdata mongodb nosql sorting
• What is going on with Database Mail in SQL Server

  by SQLDenis on January 15, 2013

  database mail mail sql server 2008 sql server 2012
• Database Mail maintenance in SQL Server

  by SQLDenis on January 14, 2013
• Setting up SQL Server Database Mail with gmail

  by SQLDenis on January 13, 2013

  database mail gmail sql server 2005 sql server 2008 sql server 2012
• Doing UPSERTs in MongoDB

  by SQLDenis on January 12, 2013

  bigdata mongodb nosql
• Getting started with Execution Plans

  by Axel Achten (axel8s) on January 10, 2013

  execution plan query plan
• Database Projects – Installing the Database Project Template

  by Axel Achten (axel8s) on January 8, 2013

  database lifecycle database projects sql server datatools ssdt
• Creating MongoDB as a service on Windows 8

  by SQLDenis on January 5, 2013

  bigdata mongodb nosql
• Why you shouldn't use SELECT *

  by Axel Achten (axel8s) on January 2, 2013

  select select star t-sql
• SQL Advent 2012: Recap

  by SQLDenis on December 25, 2012

  ddl designers sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 24: Getting help

  by SQLDenis on December 24, 2012

  forums help sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 twitter
• SQL Advent 2012 Day 21: With VLDBs it matters what you do and how you do it

  by SQLDenis on December 22, 2012

  indexing performance query sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 very large databases vldb
• SQL Advent 2012 Day 19: How to improve your tech skills

  by SQLDenis on December 19, 2012
• A Look Inside SQL Server Row and Page Compression

  by Jes Borland on December 19, 2012
• SQL Advent 2012 Day 17: No matter how long you are on the wrong path, go back

  by SQLDenis on December 17, 2012
• SQL Advent 2012 Day 15: Benefits of Indexes

  by SQLDenis on December 15, 2012

  indexing performance query sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012
• SQL Advent 2012 Day 13: Features enabled that are not used

  by SQLDenis on December 13, 2012

  features sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• \"The What, Why, and How of Filegroups\" – I-380 PASS Materials

  by Jes Borland on December 12, 2012
• SQL Advent 2012 Day 12: Proactive notifications

  by SQLDenis on December 12, 2012

  errors notifications sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 11: Cursors and loops

  by SQLDenis on December 11, 2012

  cursors loops sql server 2005 sql server 2008 sql server 2012
• Update Table Based on a JOIN

  by Ted Krueger (onpnt) on December 11, 2012
• SQL Advent 2012 Day 9: Reinventing the wheel

  by SQLDenis on December 9, 2012

  community help sql server 2008 sql server 2012 twitter
• SQL Server Data Type Conversion Poster is available for download

  by SQLDenis on December 8, 2012

  chart conversions data types pdf poster sql server 2012
• SQL Advent 2012 Day 8: Foreign Keys

  by SQLDenis on December 8, 2012

  constraints data integrity foreign keys sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 7: Lack of constraints

  by SQLDenis on December 7, 2012

  constraints data integrity sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 6: Standardized Naming And Other Conventions

  by SQLDenis on December 6, 2012

  conventions ddl designers sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 5: Do not trust the SSMS designers

  by SQLDenis on December 5, 2012

  ddl designers sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 ssms
• SQL Advent 2012 Day 4: Triggers, what to do, what not to do

  by SQLDenis on December 4, 2012

  database ddl triggers dml triggers rdbms sql sql server 2008 sql server 2012 t-sql triggers
• SQL Advent 2012 Day 3: Sargable Queries

  by SQLDenis on December 3, 2012

  database indexing performance tuning rdbms sargable sql sql server 2008 sql server 2012 t-sql
• SQL Advent 2012 Day 2: Data types storage differences

  by SQLDenis on December 2, 2012

  backup conversions log performance sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 storage
• SQL Advent 2012 Day 1: Sizing database files

  by SQLDenis on December 1, 2012

  filegroups files log sql advent 2012 sql server 2008 sql server 2008 r2 sql server 2012 tempdb
• Book Review: Microsoft SQL Server 2012 T-SQL Fundamentals

  by Axel Achten (axel8s) on November 27, 2012

  book review microsoft press sql server 2012 t-sql
• SQL Advent 2012, here is what is coming

  by SQLDenis on November 25, 2012

  database design how to sql server 2000 sql server 2005 sql server 2008 sql server 2012 tables
• Cardinality Estimate and Computed Columns

  by Ted Krueger (onpnt) on November 16, 2012
• Short-Throw-Away T-SQL

  by Ted Krueger (onpnt) on November 15, 2012
• A Few Notes About Creating Custom SSMS Reports

  by Jes Borland on October 31, 2012
• Hex Editoring

  by Jes Borland on October 30, 2012
• SELECT 1 – Column Level Security

  by Ted Krueger (onpnt) on October 30, 2012
• I'm An Author! "Pro SQL Server 2012 Practices" Releases October 31

  by Jes Borland on October 25, 2012
• Adding nonclustered index on primary keys

  by Ted Krueger (onpnt) on October 11, 2012
• Why do you need additional privileges for truncate table compared to delete?

  by SQLDenis on October 7, 2012

  delete how to permissions sql server 2005 sql server 2008 sql server 2012 truncate table
• Free SQL Server Tools

  by Jes Borland on August 31, 2012
• SQL Server 2008 R2 SP2 Released

  by SQLDenis on July 27, 2012

  service pack sql server 2008 r2 support
• How to create a simple cross tab report in Reporting Services 2008

  by David Forck (thirster42) on July 3, 2012
• Balanced Data Distributor for SSIS 2012 Released

  by Ted Krueger (onpnt) on June 20, 2012
• OUTPUT Clause and @@identity, scope_identity()

  by SQLDenis on May 25, 2012

  dml insert output sql server 2005 sql server 2008 sql server 2012
• How to change the SA password in SQL Server

  by SQLDenis on May 22, 2012

  security sql server 2005 sql server 2008
• Don't put a return statement in a stored procedure inside a transaction

  by SQLDenis on May 18, 2012

  how to sql server 2005 sql server 2008 sql server 2012 tip
• SQL Azure How To Rebuild A Clustered Index

  by SQLDenis on May 3, 2012

  azure cloud computing fragmentation sql azure
• A couple of things to be aware of when working with tables in SQL Azure

  by SQLDenis on May 2, 2012

  azure sql azure the cloud
• How to search for data with underscores or brackets in SQL Server?

  by SQLDenis on May 2, 2012

  like regular expressions s ql server 2005 sql server 2000 sql server 2008 sql server 2012
• Please don't use blacklists, use parameterized queries or stored procs instead

  by SQLDenis on April 5, 2012

  best practices security sql injection
• Downloading SQL Server Sample Databases much improved with new CodePlex changes

  by SQLDenis on April 3, 2012

  database samples sql server 2005 sql server 2008 sql server 2012
• Dammit people, get to know check constraints and use them!

  by SQLDenis on April 3, 2012

  check constraints ow to sql server 2005 sql server 2008 sql server 2012 tip trick
• Report Builder 3.0 – Map Wizard

  by Jes Borland on March 28, 2012
• Presenting "Filegroups: Putting the Pieces Together" for Chicago SQL Connections

  by Jes Borland on March 26, 2012
• How to give permissions to User-Defined Table Types

  by SQLDenis on March 21, 2012
• Grouping and merging data with CROSS APPLY

  by Axel Achten (axel8s) on March 12, 2012

  cross apply for xml merging columns sql server
• Report Builder 3.0 – Chart Types, Visualizations, and Properties

  by Jes Borland on March 8, 2012
• Report Builder 3.0 – Chart Wizard

  by Jes Borland on February 29, 2012
• Report Builder 3.0 – Table or Matrix Wizard

  by Jes Borland on February 22, 2012
• Report Builder 3.0 – The Introduction

  by Jes Borland on February 15, 2012
• Getting the list of parameters from a stored procedure by using sqlCmd.Parameters or INFORMATION_SCHEMA.parameters

  by SQLDenis on February 14, 2012

  parameters stored procedure
• Difference between a cross join and a full outer join

  by SQLDenis on February 12, 2012

  joins sql server 2000 sql server 2005 sql server 2008 sql server 2012 t-sql
• It's Hard To Be "Average": Mean, Median, and Mode in SQL Server

  by Jes Borland on February 8, 2012

  average mean median mode sql server
• SQL Server and xp_cmdshell – The good, the bad and more ugly

  by Ted Krueger (onpnt) on February 7, 2012
• Automating Index Statistics Collection with SSIS – The fast one

  by Ted Krueger (onpnt) on January 27, 2012
• Automating Index Statistics Collection

  by Ted Krueger (onpnt) on January 25, 2012
• Cheatsheet: Relational Database Management Systems Comparison

  by Jes Borland on January 24, 2012
• Estimating Mean Uptime for Team-based uptime measurements

  by Ted Krueger (onpnt) on January 23, 2012
• Could not find stored procedure 'sp_ExecuteSQL'

  by Ted Krueger (onpnt) on January 19, 2012
• How I use PowerShell to generate table output for blog posts from query results

  by SQLDenis on January 19, 2012

  blogging powershell scripting
• How to connect to SQL Server when your default database is unavailable

  by SQLDenis on January 14, 2012

  connecting connection how to sql server 2005 sql server 2008 tip
• Friday SQL Nugget #1

  by Jes Borland on January 13, 2012
• WiSSUG "Filegroups: Putting the Pieces Together" Materials

  by Jes Borland on January 11, 2012
• MySQL MyISAM and InnoDB Engine Differences

  by Jes Borland on January 10, 2012
• SQLCop integration with Red Gate's SQL Test

  by George Mastros (gmmastros) on January 4, 2012

  sql test sqlcop tsqlt
• Book Review: Microsoft SQL Server 2008 Internals

  by Jes Borland on January 4, 2012
• SQL Azure Compatibility Assessment service released

  by SQLDenis on January 4, 2012

  azure cloud computing sql azure
• Presenting "Filegroups: Putting The Pieces Together" for WiSSUG

  by Jes Borland on January 3, 2012
• Scripting data in SQL Server 2012

  by SQLDenis on January 2, 2012

  scripting
• Upgrade Assistant for SQL Server 2012 available for download

  by SQLDenis on December 23, 2011

  sql server 2005 sql server 2008 sql server 2012 upgrade
• SQL Advent 2011 Day 23: OBJECT_DEFINITION

  by SQLDenis on December 23, 2011

  metadata object_definition sql server 2005 sql server 2008 stored procedures
• SQL Advent 2011 Day 21: TRY CATCH

  by SQLDenis on December 21, 2011

  error error handling sql server 2005 sql server 2008 try catch
• Replacing sysfiles With sys.database_files

  by Jes Borland on December 21, 2011
• SQL Advent 2011 Day 19: Filtered Indexes

  by SQLDenis on December 19, 2011

  indexing sql server 2005 sql server 2008
• SQL Advent 2011 Day 18: Table-valued Parameters

  by SQLDenis on December 18, 2011

  sql server 2008 table-valued parameters tvp
• SQL Advent 2011 Day 17: varchar(max)

  by SQLDenis on December 17, 2011

  data types ntext nvarchar(max) sql server 2005 sql server 2008 text varchar(max)
• SQL Advent 2011 Day 15: Joins

  by SQLDenis on December 16, 2011

  how to joins sql server 2005 sql server 2008 tip
• SQL Server Integration Services tools to have – Configuration File Editor

  by Ted Krueger (onpnt) on December 15, 2011
• SQL Advent 2011 Day 14: EXCEPT and INTERSECT SET Operations

  by SQLDenis on December 15, 2011

  except intersect sql server 2005 sql server 2008 union
• SQL Advent 2011 Day 13: DDL Triggers

  by SQLDenis on December 13, 2011

  auditing ddl triggers triggers
• Fixing orphaned database users in 2005 to 2012 – T-SQL Tuesday #025

  by Ted Krueger (onpnt) on December 13, 2011
• Zero-One-Some Testing

  by George Mastros (gmmastros) on December 13, 2011

  tsqlt unit testing
• SQL Advent 2011 Day 12: Table Value Constructor

  by SQLDenis on December 12, 2011

  how to sql server 2008 table value constructor tip
• SQL Advent 2011 Day 10: Upsert by using the Merge statement

  by SQLDenis on December 10, 2011

  how to merger sql server 2008 tip upsert
• Presentation Files: EDMPASS and ABQ SQL

  by Jes Borland on December 9, 2011
• Merge Replication – Parameterized Filters

  by Ted Krueger (onpnt) on December 9, 2011
• SQL Server Integration Services tools to have – Expression Editor & Tester

  by Ted Krueger (onpnt) on December 8, 2011
• Dynamic Connections in SSIS – Extract, Transform and Load

  by Ted Krueger (onpnt) on December 7, 2011
• Shared Connections – New level of efficiency in SSIS 2012

  by Ted Krueger (onpnt) on December 6, 2011
• SQL Advent 2011 Day 5: Common Table Expressions

  by SQLDenis on December 5, 2011

  common table expression cte tables
• SQL Advent 2011 Day 4: Schemas

  by SQLDenis on December 4, 2011

  how to schema skills sql server 2005 sql server 2008
• How to call a user defined function with a default parameter

  by SQLDenis on December 2, 2011

  function gotcha sql server 2005 sql server 2008 tip
• How to capture the error output from a stored procedure when calling another stored procedure in SQL Server?

  by SQLDenis on December 1, 2011

  error how to output parameter sql server 2005 sql server 2008 tip
• SQL Advent 2011 Day 1: Date and time

  by SQLDenis on December 1, 2011

  dates datetime datetime2 gotcha sql server 2008 time
• Anecdotes about SQL AKA post 400

  by SQLDenis on November 30, 2011

  anecdote sql sql server
• Showing sysjobhistory run_duration in HHMMSS format

  by SQLDenis on November 17, 2011
• SQL Server 2012 RC0 is here!

  by Ted Krueger (onpnt) on November 17, 2011
• List all stored procedures that run at startup in SQL Server

  by SQLDenis on November 15, 2011

  administration sql server 2005 sql server 2008
• T-SQL Tuesday #024: Reporting Services, Stored Procedures, and Multiple Result Sets

  by Jes Borland on November 8, 2011
• SSIS Interview questions – Answers

  by Ted Krueger (onpnt) on November 3, 2011
• SSIS Test yourself with these interview questions

  by Ted Krueger (onpnt) on November 1, 2011
• SQL Saturday #99 Minnesota – #SQLAwesome

  by Ted Krueger (onpnt) on October 26, 2011
• PASS Summit 2011: Reporting Services 201 Wrap-Up

  by Jes Borland on October 21, 2011
• PASS Summit 2011: A Picture Book

  by Jes Borland on October 18, 2011
• SQL Server 2008 Service Pack 3 has been released

  by SQLDenis on October 6, 2011

  service pack sql server 2008
• Fix Execution Plan showing Parallelism

  by Ted Krueger (onpnt) on October 6, 2011
• SQL Server Views and Metadata

  by Ted Krueger (onpnt) on October 6, 2011
• SQL Saturday #92 – Portland, OR

  by Jes Borland on October 3, 2011
• SQL Server Deep Dives Volume 2

  by Ted Krueger (onpnt) on October 2, 2011
• Troubleshooting SQL Server: A guide for the Accidental DBA

  by Ted Krueger (onpnt) on October 2, 2011
• 2011 Quarter 3 Goals: Kicking [beep], Taking Names

  by Jes Borland on September 30, 2011
• Returning a value inserted in a table with a newsequentialid() default on a uniqueidentifier column

  by SQLDenis on September 23, 2011

  database how to sql server 2005 sql server 2008 uniqueidentifier
• Tips and Tricks to Make SQL Server Management Studio Awesome

  by Jes Borland on September 22, 2011
• Attending PASS Summit 2011? Want Lunch? And Free Career Advice? I Have Just The Event...

  by Jes Borland on September 15, 2011
• Use common table expressions to simplify your updates in SQL Server

  by SQLDenis on September 10, 2011

  common table expression cte data manipulation sql server updates
• How much longer will the SQL Server database restore take

  by SQLDenis on September 2, 2011

  dmv dynamic management views restore
• Watch Me (and 23 Others!) During 24 Hours of PASS: Summit Preview

  by Jes Borland on August 31, 2011
• Microsoft SQL Server, codename "Denali", will be the last release to support OLE DB, ODBC is the new new thing

  by SQLDenis on August 30, 2011

  denali odbc ole db sql server sql server denali
• Reporting Services Error: "The tablix has a detail member with inner members" (And How To Fix It)

  by Jes Borland on August 19, 2011
• T-SQL Tuesday

  by Ted Krueger (onpnt) on August 10, 2011
• T-SQL Wednesday #21 – T-SQL That Should Have Been Flushed Down the Toilet

  by Jes Borland on August 10, 2011
• Chicago SQL Connections – Reporting Services 201 Slides & Code

  by Jes Borland on August 4, 2011
• SQL Injection Pocket Reference for MySQL, SQL Server and Oracle

  by SQLDenis on July 29, 2011

  mysql oracle security sql injection sql server
• How to find what column caused the String or binary data would be truncated message

  by SQLDenis on July 27, 2011

  errors importing truncation
• A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation

  by Jes Borland on July 22, 2011
• tSQLt Unit Testing

  by George Mastros (gmmastros) on July 20, 2011
• TRY_CONVERT in SQL Server Denali CTP3

  by SQLDenis on July 19, 2011

  denali functions sql server try_convert
• SQL Server Columnstore Index FAQ wiki page published

  by SQLDenis on July 15, 2011

  columnstore
• Concat function in SQL Server Denali CTP3

  by SQLDenis on July 15, 2011

  concat denali functions sql server
• ColumnStore Index limitations in SQL Server Denali CTP3

  by SQLDenis on July 14, 2011

  apollo columnstore denali olap oltp
• DATEFROMPARTS and DATETIMEFROMPARTS functions in SQL Server Denali CTP3

  by SQLDenis on July 13, 2011

  dates denali functions
• A Quick look at the new EOMONTH function in SQL Server Denali CTP3

  by SQLDenis on July 13, 2011

  dates denali functions
• A Quick look at the new IIF function in Denali CTP3

  by SQLDenis on July 13, 2011

  denali functions iif
• SQL Server Code Name "Denali" CTP3 is available for download

  by SQLDenis on July 12, 2011

  denali
• T-SQL Tuesday #20 – T-SQL Best Practices

  by Jes Borland on July 12, 2011
• Excel 2010 Data Source "From Microsoft Query" Missing DSNs

  by Jes Borland on June 30, 2011
• User Groups? Those Still Exist? They Do, and You Should Be Going To One

  by Jes Borland on June 24, 2011
• I'm Speaking! PASS Summit 2011

  by Jes Borland on June 17, 2011
• Do you care that SQL Server Denali cannot be installed on Windows XP?

  by SQLDenis on June 15, 2011

  denali sql server windows 7 windows xp
• SQL Saturday #75, Columbus OH: I Came, I Saw, I Ran

  by Jes Borland on June 14, 2011
• A week in Sybase Training, what did I learn, day 5

  by SQLDenis on June 10, 2011

  ase sql server sybase training
• A week in Sybase Training, what did I learn, day 4

  by SQLDenis on June 9, 2011

  ase sql server sybase training
• A week in Sybase Training, what did I learn, day 2

  by SQLDenis on June 7, 2011

  ase sql server sybase training
• A week in Sybase Training, what did I learn, day 1

  by SQLDenis on June 6, 2011

  ase sql server sybase training
• I'll See You At SQL Saturday #75 Columbus, OH

  by Jes Borland on June 6, 2011
• SQL Saturday Pensacola – Measure of success

  by Ted Krueger (onpnt) on June 6, 2011
• Do you still use sp_change_users_login instead of ALTER USER UserName WITH LOGIN = UserName

  by SQLDenis on June 3, 2011

  permissions sql server 2005 sql server 2008 sql server 2008 r2
• Book Review: Securing SQL Server By Denny Cherry

  by SQLDenis on May 27, 2011
• Watch all the Tech·Ed North America 2011 SQL Server videos

  by SQLDenis on May 19, 2011

  sql server 2008 r2 sql server denali videos
• SQL Server DBA Tip 16 – Working with Files and Folders

  by Ted Krueger (onpnt) on May 17, 2011
• T-SQL Tuesday #18: A Recursive CTE Is: A Recursive CTE Is

  by Jes Borland on May 10, 2011
• Removing OS Files Through a Stored Procedure

  by SQLology ~ Kim Tessereau on May 7, 2011
• Match your defaults with your trigger values to prevent horrible fragmentation on your indexes and tables

  by SQLDenis on May 6, 2011

  pitfalls sql server 2000 sql server 2005 sql server 2008 triggers
• SQL Server DBA Tip 4 – Server Considerations – 32 bit / 64 bit

  by Ted Krueger (onpnt) on April 29, 2011
• Difference between a Cumulative Update and Service Pack for SQL Server

  by Ted Krueger (onpnt) on April 23, 2011
• SQL Server 2008 R2 SP1 CTP Available for download

  by SQLDenis on April 22, 2011

  service pack sql server 2008 r2
• Use DDL Triggers To Track Table Changes

  by SQLDenis on April 21, 2011

  alter table auditing ddl ddl triggers triggers
• Why do we need error handling?

  by SQLology ~ Kim Tessereau on April 17, 2011
• When changing column data types use ALTER TABLE TableName ALTER Column syntax, don't drop and recreate column

  by SQLDenis on April 10, 2011

  dates datetime datetime2 gotcha sql server 2008
• Be careful when passing around parameters, make sure they are the same size and type

  by SQLDenis on April 8, 2011

  best practice data types gotcha pitfalls sql server
• Bulk loading data into a merge replicated table

  by Ted Krueger (onpnt) on April 8, 2011
• What does the lock icon mean in SSMS when looking at a stored procedure?

  by SQLDenis on April 6, 2011

  permissions ssms stored procedures
• Use a database how it was intended to be used

  by SQLDenis on April 4, 2011

  design normalization
• Using STOPAT in the RESTORE DATABASE Statement

  by Jes Borland on April 4, 2011
• We ain't afraid of no errors!

  by SQLology ~ Kim Tessereau on April 3, 2011
• Automate Database Restore to Remote Instance with SSIS

  by Ted Krueger (onpnt) on March 30, 2011
• Use the GROUPING function to determine whether a value is NULL because of ROLLUP

  by SQLDenis on March 23, 2011

  aggregations functions group by grouping rollup sql server 2008
• SQL Saturday #67 Chicago 2011: Have Fun Storming the Castle!

  by Jes Borland on March 21, 2011
• 24 Hours of PASS: Wrap-Up, Slides, Demos and High-Fives

  by Jes Borland on March 17, 2011
• SUM (T-SQL Tuesday #016: Aggregate Functions)

  by Jes Borland on March 10, 2011
• Understanding SQL Server 2000 Pivot with Aggregates

  by George Mastros (gmmastros) on March 8, 2011
• T-SQL Tuesday #016 – COUNT and DELETE duplicates

  by Ted Krueger (onpnt) on March 8, 2011
• Learn the platform differences to be more effective

  by SQLDenis on March 7, 2011

  alter table columns sql server 2005 sql server 2008 tip
• New Collection of SQL Server Videos on Channel 9

  by SQLDenis on March 5, 2011

  denali howto sql server 2008 r2 videos
• Come One, Come All to T-SQL Tuesday #016 : Aggregate Functions

  by Jes Borland on February 26, 2011
• What does a SQL Server developer need to know?

  by SQLDenis on February 21, 2011

  how to skills sql server 2005 sql server 2008
• Latest article by SQL Server MVP Erland Sommarskog is a gem

  by SQLDenis on February 21, 2011

  how to performance sql server 2005 sql server 2008 ssms tip
• Trapping errors when working with linked servers

  by SQLDenis on February 15, 2011

  errors how to linked servers trapping
• Renaming Physical Database Files

  by Ted Krueger (onpnt) on February 9, 2011
• How To Unpivot (and pivot) Like a Boss

  by David Forck (thirster42) on February 8, 2011

  mssql pivot t-sql unpivot
• T-SQL Tuesday#15 – Automation with PowerShell (Replace with RegEx)

  by Ted Krueger (onpnt) on February 8, 2011
• Using Database Snapshot As A Protection Against Rogue Deletes

  by SQLDenis on February 2, 2011

  delete snapshot sql server 2005 sql server 2008
• Backup file contents with SSIS – Supporting tables and procedures

  by Ted Krueger (onpnt) on January 28, 2011
• How to Delete Large amounts of data in a Batch.

  by ptheriault on January 20, 2011
• Using RMO to run replication tasks

  by Ted Krueger (onpnt) on December 30, 2010

  replication rmo sql server 2008
• Procedure expects parameter error from SqlCommand

  by Ted Krueger (onpnt) on December 27, 2010

  .net c# slqcommand sql server
• How to move datafiles to a new drive in SQL Server

  by SQLDenis on December 17, 2010

  administration files sql server 2005 sql server 2008
• T-SQL Tuesday #13: Is that what you really want?

  by George Mastros (gmmastros) on December 14, 2010
• T-SQL Tuesday #13: What the Business Says Is Not What the Business Wants

  by Ted Krueger (onpnt) on December 14, 2010

  cubes olap reporting sql server t-sql tuesday
• SSRS: How to monitor report subscriptions

  by ptheriault on December 8, 2010
• Dealing with The row value(s) updated or deleted either do not make the row unique or they alter multiple rows errors

  by SQLDenis on December 8, 2010

  normalization sql server denali ssms
• Mirroring and Transactional Replication setup – Auto Failover

  by Ted Krueger (onpnt) on November 30, 2010

  mirroring replication sql server 2005 sql server 2008 transactional replication
• Run SSIS Package from Stored Procedure

  by Ted Krueger (onpnt) on November 29, 2010

  sql server 2008 sql server integration services ssis
• Using SSIS to import a directory of images

  by Ted Krueger (onpnt) on November 24, 2010

  import image rapid development sql server 2008 sql server integration services ssis
• SQL Server Denali CTP1 Announced at PASS

  by SQLDenis on November 9, 2010

  ctp database sql server denali
• Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object

  by SQLDenis on November 9, 2010

  ctp database sql server denali
• Find what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters

  by SQLDenis on November 9, 2010

  ctp database sql server denali
• Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging

  by SQLDenis on November 9, 2010

  ctp database sql server denali
• Debugging In SQL Server Denali

  by SQLDenis on November 9, 2010

  ctp database sql server denali
• Screenshots of the new look and feel of BIDS in Denali

  by SQLDenis on November 9, 2010

  bids ctp database sql server denali ssis
• What SQL Server book would you recommend for a Sybase and Oracle admin?

  by SQLDenis on November 8, 2010

  books sql server 2008
• Use an OUTER LOOP JOIN for faster performance when one of the tables is much smaller

  by SQLDenis on November 5, 2010
• Execution Plans – Indexing to achieve optimal query plans

  by Ted Krueger (onpnt) on October 25, 2010

  execution plans pass sql server 2008 sql server community tuning
• Who shrunk the files? (DBCC SHRINKFILE Audit)

  by Ted Krueger (onpnt) on October 22, 2010
• Tokenizing filenames in SQL Server

  by SQLDenis on October 20, 2010

  function pivot sql server 2005 sql server 2008 transpose
• SQLCop behind a Proxy

  by Ted Krueger (onpnt) on October 18, 2010

  best practices sql server 2008 sql server community sqlcop
• Wisconsin SQL Server User Group

  by Ted Krueger (onpnt) on October 11, 2010

  execution plans pass sql server 2008 sql server user group wissug
• The History of SQL Server Integration Services

  by Ted Krueger (onpnt) on October 11, 2010

  sql server 2008 r2 sql server history sql server integration services ssis
• SSIS runs in BIDS but not with SQL Agent

  by Ted Krueger (onpnt) on October 6, 2010

  sql server 2008 r2 sql server agent failure sql server integration services ssis
• How to flip a bit in SQL Server by using the Bitwise NOT operator

  by SQLDenis on September 29, 2010

  bits bitwise bool math sql server 2005 sql server 2008 tinyint
• How to capture the error output from xp_cmdshell in SQL Server

  by SQLDenis on September 22, 2010

  error how to sql server 2005 sql server 2008 tip trick xp_cmdshell
• SQL Saturday #46, Raleigh NC

  by Eli Weinstock-Herman (tarwn) on September 22, 2010

  community sqlsaturday
• Have SQL, will travel – East Iowa SQL Saturday

  by Ted Krueger (onpnt) on September 20, 2010

  configuration files configuration variables dtsx parent child packages sql saturday sql server 2008 ssis
• SQL Saturday Iowa

  by Ted Krueger (onpnt) on September 11, 2010

  sql community sql server sql server 2008 sql server integration services ssis
• When should you store @@ROWCOUNT into a variable?

  by SQLDenis on September 10, 2010

  rowcount error gotcha how to sql server 2005 sql server 2008 tip
• Dealing with The multi-part identifier "dbo.Table.Column" could not be bound. error in an update statement

  by SQLDenis on September 1, 2010

  error gotcha sql server 2000 sql server 2005 sql server 2008 update
• The Lazy DBA Series: Wizards!

  by Ted Krueger (onpnt) on August 25, 2010

  database administration import wizard sql server sqlpass
• Searching for ranges when you have quarters and years

  by SQLDenis on August 25, 2010

  calendar dates how to quarters
• The Lazy DBA Series: High Availability

  by Ted Krueger (onpnt) on August 24, 2010

  database administration sql server sqlpass
• The Lazy DBA Series: Email me, I'm broke!

  by Ted Krueger (onpnt) on August 24, 2010
• SQLCop update Version 1.1

  by George Mastros (gmmastros) on August 23, 2010
• The Lazy DBA Series: Monitoring

  by Ted Krueger (onpnt) on August 22, 2010

  baseline monitoring performance red gate reporting sql response sql server 2008
• The Lazy DBA Series: SQL Trace / Profiler

  by Ted Krueger (onpnt) on August 20, 2010

  database administration sql server sqlpass
• Making SSIS Dynamic: Passing variables between packages

  by Ted Krueger (onpnt) on August 19, 2010

  configuration files configuration variables dtsx parent child packages sql server 2008 ssis
• Making SSIS Dynamic: Configuration Management

  by Ted Krueger (onpnt) on August 18, 2010

  configuration files configuration variables dtsx parent child packages sql server 2008 ssis
• SQL Saturday 28, Baton Rouge

  by Eli Weinstock-Herman (tarwn) on August 16, 2010

  community sqlsaturday
• Creating a baseline for SQL Server

  by Ted Krueger (onpnt) on August 9, 2010

  baseline monitoring performance sql server sql server 2008
• How to return only weekend data for the last 4 weeks in SQL Server

  by SQLDenis on August 6, 2010

  dates howto sql server 2008 sql server 2005
• Baseline, Performance Reporting and being a proactive DBA

  by Ted Krueger (onpnt) on August 5, 2010

  baseline monitoring performance reporting sql server 2008
• Display Monthly Totals Going Across in SSRS 2005

  by rwaters on July 28, 2010

  business intelligence matrix sql server reporting services sql server reporting services 2005 ssrs
• SQLCop A Tool To Highlight Potential Problems With Your Database

  by SQLDenis on July 25, 2010

  sql sql server sqlcop
• RID Lookup take me down

  by Ted Krueger (onpnt) on July 18, 2010

  execution plan query tuning rid lookup sql server 2008 t-sql
• Change Data Capture rundown 100 (setup)

  by Ted Krueger (onpnt) on July 12, 2010

  cdc change data capture new features sql server 2008 tracking data
• Checking for NULL values in all columns that allow NULLS in all the tables

  by SQLDenis on June 16, 2010

  howto sql server 2005 sql server 2008 t-sql tip
• SQL Server and the Auto Close Setting

  by Ted Krueger (onpnt) on June 12, 2010

  auto close deprecated list sql community sql server
• SQL Server and High Availability

  by Ted Krueger (onpnt) on June 11, 2010

  backup disaster recovery dr ha high availability log shipping mirroring restore sql server 2008 sql university
• SQL University – Recess time!

  by Ted Krueger (onpnt) on June 10, 2010

  backup disaster recovery dr ha high availability log shipping mirroring restore sql server 2008 sql university
• Log Shipping for cheap DR

  by Ted Krueger (onpnt) on June 10, 2010

  backup disaster recovery dr ha high availability log shipping mirroring restore sql server 2008
• T-SQL Tuesday – Give me my cores SSIS 2008!

  by Ted Krueger (onpnt) on June 8, 2010

  sql community sql server 2008 sql server 2008 r2 sql server integration services ssis ssis 2008
• The SQL Server backup – foundation of any Disaster / Recovery

  by Ted Krueger (onpnt) on June 8, 2010

  backup disaster recovery dr ha high availability mirroring restore sql server 2008
• Welcome to HA and DR week!

  by Ted Krueger (onpnt) on June 7, 2010
• How to refresh the local IntelliSense cache in SQL Server Management Studio

  by SQLDenis on June 5, 2010

  intellisense tip trick
• Removing old files with SSIS

  by Ted Krueger (onpnt) on June 4, 2010

  delete files sql community sql server sql server 2008 sql server integration services ssis
• Report Manager / Report Server Loading Slow Initially

  by Ted Krueger (onpnt) on May 28, 2010

  report manager report server sql server reporting services ssrs
• Transaction Log expanding on restore after shrink

  by Ted Krueger (onpnt) on May 27, 2010

  backup ldf restore shrinkfile sql server sql server 2008 transaction log
• Three different ways of populating variables with configuration values in SQL Server

  by SQLDenis on May 19, 2010

  howto sql server 2000 sql server 2005 sql server 2008 tip
• 12 ways to break your database server before the first transaction

  by Ted Krueger (onpnt) on May 19, 2010

  dmf dmv index maintenance performance sql server 2005 sql server 2008
• How to use T-SQL to get the command line startup parameters that were used to start SQL Server

  by SQLDenis on May 18, 2010

  howto sql server 2005 sql server 2008 tip
• How to get the processid that SQL Server is using if you have multiple instances of SQL Server running

  by SQLDenis on May 12, 2010

  how to sql server 2005 sql server 2008 tip
• Five things wouldn't miss in SQL Server

  by Ted Krueger (onpnt) on May 11, 2010

  meme sql server tagged
• Trusting Database Engine Tuning Advisor for Query Tuning

  by Ted Krueger (onpnt) on May 11, 2010

  database engine tuning advisor index maintenance sql server 2005 sql server 2008
• Mirroring Hands On with Developer Edition

  by Ted Krueger (onpnt) on May 9, 2010

  high availability mirroring sql server 2008
• SQL Connections Suburban Chicago Wrap Up

  by Ted Krueger (onpnt) on May 6, 2010

  community help pass sql server ssug
• Planning your hardware for SQL Server Mirroring

  by Ted Krueger (onpnt) on May 4, 2010

  high availability mirroring sql server 2008
• SSIS A difference between C# and VB in a script task

  by SQLDenis on May 3, 2010

  c# ssis vb
• SQL Connections Suburban Chicago May 2010 Meeting (SSIS Basics)

  by Ted Krueger (onpnt) on May 3, 2010

  sql community sql server sql server integration services ssis
• Planning your SQL Server mirroring landscape

  by Ted Krueger (onpnt) on May 3, 2010

  high availability mirroring sql server 2008
• How to insert values into a table with only an identity column

  by SQLDenis on April 30, 2010

  how to identity tip
• Debugging 64 bit SSIS packages

  by SQLDenis on April 25, 2010

  debugging howto ssis yip
• SQL Saturday New York City recap

  by SQLDenis on April 25, 2010

  community sqlsaturday
• Stripping rows out of file imports

  by Ted Krueger (onpnt) on April 22, 2010
• Do you use disable index or drop index when running your ETL processes in SQL Server

  by SQLDenis on April 21, 2010

  indexing question
• Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform

  by SQLDenis on April 15, 2010

  performance pitfalls sql server 2000 sql server 2005 sql server 2008 tip
• MongoDB vs. SQL Server – INSERT comparison part deux

  by SQLDenis on April 6, 2010

  mongodb nosql performance
• Delay Validation with SSIS Tasks

  by Ted Krueger (onpnt) on April 5, 2010

  integrated services sql server ssis
• Getting the physical device name and backup time for a SQL Server database

  by SQLDenis on April 2, 2010

  backup recovery sql server 2005 sql server 2008
• Index DMV usage considerations

  by Ted Krueger (onpnt) on March 31, 2010

  dmf dmv index maintenance performance sql server 2005 sql server 2008
• Finding meaningful error details to report execution failures

  by Ted Krueger (onpnt) on March 30, 2010
• Interview with me about the chapters I wrote for the SQL Server Deep Dives book

  by SQLDenis on March 26, 2010

  book interview sql server 2008
• Formatting the time from a datetime or time datatype by using the STUFF function

  by SQLDenis on March 24, 2010

  function sql server 2005 sql server 2008 stuff tip
• SQL Saturday 33 – Charlotte, NC

  by Eli Weinstock-Herman (tarwn) on March 7, 2010

  dba sqlsaturday sqlserver
• Calculating Nth weekday in a month

  by Ramireddy on March 2, 2010
• Do You Get A Benefit From Compressing Backups If You Already Have Compressed Data?

  by SQLDenis on March 2, 2010

  backups compression restores
• Choosing operating modes for mirroring over a WAN

  by Ted Krueger (onpnt) on March 2, 2010
• Using schemas to maintain order as a DBA

  by Ted Krueger (onpnt) on February 26, 2010

  dba schema sql server
• Calculating number of workdays between 2 dates

  by Ramireddy on February 25, 2010
• SQL Server Proper Case Function

  by George Mastros (gmmastros) on February 24, 2010
• SQL Saturday in Chicago – Schedule is up!

  by Ted Krueger (onpnt) on February 11, 2010
• Running sp_helpdb against a snapshot shows wrong files on SQL Server 2008

  by SQLDenis on February 11, 2010

  bug feature snapshot sql server 2008
• Use Filters in SSMS to only see the things that are of interest to you

  by SQLDenis on February 6, 2010

  productivity ssms tip
• Interesting UNION with ORDER BY behavior

  by SQLDenis on February 5, 2010

  gotcha sql server 2008
• Read from your mirror in SQL Server

  by Ted Krueger (onpnt) on February 3, 2010
• Running static code analysis on SQL Server database with Visual Studio Team System for database architects

  by SQLDenis on January 31, 2010

  code analysis sql server 2008 visual studio 2008
• Backup and copy warm-standby (log shipped) databases in SQL Server

  by Ted Krueger (onpnt) on January 27, 2010
• Use sys.dm_os_performance_counters to get your Buffer cache hit ratio and Page life expectancy counters

  by SQLDenis on January 22, 2010

  dmv performance sql server 2000 sql server 2005 sql server 2008
• Use alter table alter column to change datatypes for a column in SQL Server

  by SQLDenis on January 19, 2010

  database design how to sql server 2000 sql server 2005 sql server 2008 tables
• SQL Server 2008 R2 to be released in May

  by SQLDenis on January 19, 2010

  business intelligence gemini madison sql server 2008 sql server 2008 r2
• Activity Monitor to gather statistics and health of SQL Server 2008

  by Ted Krueger (onpnt) on January 18, 2010
• How to return all the skipped identity values from a table in SQL Server

  by SQLDenis on January 18, 2010

  gaps how to identity sql server 2005 sql server 2008
• Find Out If You Are Using Deprecated Features In SQL Server 2008

  by SQLDenis on January 14, 2010

  dmv dynamic management views sql server 2005 sql server 2008
• Interview with Brent Ozar about the book Professional SQL Server 2008 Internals and Troubleshooting

  by SQLDenis on January 13, 2010

  book interview performance tuning sql server 2008
• Find Out What Percent Of The Log Is Being Used For Each Database In SQL Server 2005 and 2008

  by SQLDenis on January 13, 2010

  dmv dynamic management views sql server 2005 sql server 2008
• Microsoft Announces SQL Server Migration Assistant for MySQL

  by SQLDenis on January 12, 2010

  azure mysql sql server 2008
• Mirroring SQL Server 2005 to SQL Server 2008 (part 2)

  by Ted Krueger (onpnt) on January 12, 2010
• Mirroring SQL Server 2005 to SQL Server 2008 (Part 1)

  by Ted Krueger (onpnt) on January 11, 2010
• SQL Azure CTP Testers Can Upgrade Their Accounts To Paid Commercial Subscriptions Starting Today

  by SQLDenis on January 4, 2010

  azure cloud computing sql azure
• Using Variables in SSIS: Purpose review and functional examples

  by Ted Krueger (onpnt) on December 31, 2009
• Script Task vs Flat File Connection Management

  by Ted Krueger (onpnt) on December 16, 2009
• Dynamic SQL Server connections in Reporting Services

  by Ted Krueger (onpnt) on December 12, 2009
• SQL Query Commenting/Uncommenting Quick Tip

  by Erik on December 11, 2009
• Introducing SQL Server to Oracle

  by Ted Krueger (onpnt) on December 11, 2009
• Procedures with cursors

  by George Mastros (gmmastros) on November 20, 2009
• Collation conflicts with temp tables and table variables.

  by George Mastros (gmmastros) on November 19, 2009
• To BUILTINAdmin or not to BUILTINAdmin

  by Ted Krueger (onpnt) on November 19, 2009
• SQL Server collation conflicts

  by George Mastros (gmmastros) on November 18, 2009
• Don't use text datatype for SQL 2005 and up

  by George Mastros (gmmastros) on November 17, 2009
• Do not use the float data type

  by George Mastros (gmmastros) on November 16, 2009
• Undetectable Distributed Deadlocks

  by Erik on November 13, 2009
• Best Practice: Do not cluster on UniqueIdentifier when you use NewId

  by George Mastros (gmmastros) on November 12, 2009
• Best Practice: Every table should have a primary key

  by George Mastros (gmmastros) on November 11, 2009
• Do not use spaces or other invalid characters in your column names

  by George Mastros (gmmastros) on November 10, 2009
• SQL Server 2008 R2 November CTP Available For Download

  by SQLDenis on November 9, 2009

  business intelligence gemini madison sql server 2008 sql server 2008 r2
• Always include precision and scale with decimal and numeric

  by George Mastros (gmmastros) on November 9, 2009
• Always include size when using varchar, nvarchar, char and nchar

  by George Mastros (gmmastros) on November 6, 2009
• SQL Server 2008 R2 Editions Pricing Announced

  by SQLDenis on November 6, 2009

  business intelligence gemini madison sql server 2008 sql server 2008 r2
• Test your Full Recovery model by restoring backups

  by Ted Krueger (onpnt) on November 5, 2009
• Don't prefix your table names with tbl

  by George Mastros (gmmastros) on November 5, 2009
• Dealing with Cannot resolve collation conflict for equal to operation errors

  by SQLDenis on October 26, 2009

  collation database gotcha programming sql server 2000 sql server 2005 sql server 2008 tip
• Series of "Bad habits to kick" by Aaron Bertrand

  by Ted Krueger (onpnt) on October 18, 2009
• SQL University and why you should be attending

  by Ted Krueger (onpnt) on October 14, 2009
• Win A Copy Of SQL Server 2008 Administration in Action

  by SQLDenis on October 13, 2009

  book freebie
• Interview With Rod Colledge About The Book SQL Server 2008 Administration in Action

  by SQLDenis on October 12, 2009

  administration book interview sql server 2008
• Derived Column and the Data Flow Task

  by Ted Krueger (onpnt) on October 8, 2009
• To SA or not to SA

  by Ted Krueger (onpnt) on October 7, 2009
• T-SQL To find Out If An Index Is Clustered Or Non Clustered

  by SQLDenis on October 6, 2009

  functions how to indexing sql server 2000 sql server 2005 sql server 2008 tip
• Calculating The Percentage Of Null Values In A Column With Transact SQL

  by SQLDenis on October 2, 2009

  how to null sql tip
• Suffer to succeed. Another SQL Server Import Story

  by Ted Krueger (onpnt) on September 30, 2009
• Review of SQL Server 2008 Administration in Action

  by SQLDenis on September 28, 2009

  book database sql server 2008
• Keep your DBA guard up at all times

  by Ted Krueger (onpnt) on September 25, 2009
• SQL Server MVP Deep Dives a book written by SQL Server MVPs supporting a good cause

  by SQLDenis on September 25, 2009

  book charity sql server 2008
• Use INDEXKEY_PROPERTY in SQL Server to determine if columns in indexes are sorted ascending or descending

  by SQLDenis on September 23, 2009

  functions indexes indexing sql server 2005 sql server 2008
• 6 ways to import data into SQL Server

  by Ted Krueger (onpnt) on September 14, 2009
• Using Mirroring to Reduce DB Migration Downtime (Part 2)

  by Ted Krueger (onpnt) on September 10, 2009
• Using Mirroring to Reduce DB Migration Downtime (Part 1)

  by Ted Krueger (onpnt) on September 10, 2009
• East Iowa SQL Saturday Oct. 17th

  by Ted Krueger (onpnt) on September 9, 2009
• SQL Server Extracting Data (again)

  by George Mastros (gmmastros) on September 9, 2009
• How I got started with SQL Server

  by Ted Krueger (onpnt) on September 8, 2009
• How I got started with SQL Server

  by SQLDenis on September 7, 2009

  meme sql server
• SSMS Tools PACK, Something Every SQL Server Developer That Uses SSMS Should Have Installed

  by SQLDenis on August 30, 2009

  sql server 2005. tools sql server 2008 ssms
• Scripting all jobs on SQL Server 2005/2008 into one file

  by SQLDenis on August 23, 2009
• SQL Server StreamInsight CTP2 Available For Download

  by SQLDenis on August 22, 2009

  business intelligence sql server 2008 r2 streaminsight
• Scripting All The Jobs On Your SQL Server Instance Into Separate Files By Using SMO

  by SQLDenis on August 18, 2009

  jobs msdb scripting smo
• Recover a database without the ldf file

  by Ted Krueger (onpnt) on August 13, 2009
• Working with Excel to match data 101

  by Ted Krueger (onpnt) on August 5, 2009
• SQL Server sprawl, heard it twice in one day

  by SQLDenis on August 5, 2009

  sql server sprawl
• Finding Out How Many Times A Table Is Being Used In Ad Hoc Or Procedure Calls In SQL Server 2005 And 2008

  by SQLDenis on August 3, 2009

  dmv dynamic management view sql server 2005 sql server 2008 tip trick
• Instance design; Where to do your work as a DBA and DB Developer

  by Ted Krueger (onpnt) on July 28, 2009
• Dynamic Data Sources in SSRS

  by Ted Krueger (onpnt) on July 24, 2009

  ssrs
• When Books On Line is not really correct

  by SQLDenis on July 24, 2009

  books on line bug documentation gotcha sql server 2008
• The differences between LEN and DATALENGTH in SQL Server

  by SQLDenis on July 20, 2009

  datalength gotcha len t-sql
• How to get data out of Microsoft Dynamics Great Plains

  by David Forck (thirster42) on July 10, 2009
• Go ahead and click it! I triple dog dare you!!!

  by Ted Krueger (onpnt) on July 10, 2009
• Push your DBA skills over the edge by becoming a better developer

  by Ted Krueger (onpnt) on July 9, 2009
• A couple of ways of getting the top 2 distinct values from a set in SQL Server

  by SQLDenis on July 8, 2009

  queries sql transact-sql
• Dynamic column names and fields in SSRS (Custom Matrix)

  by Ted Krueger (onpnt) on July 1, 2009
• DBA SQLCLR Procedures

  by Ted Krueger (onpnt) on June 26, 2009
• Not a fan of the Report Manager in SSRS? Using SSRS procedures to get the job done

  by Ted Krueger (onpnt) on June 25, 2009
• Replace Your Case When Then Else Syntax With the Sign Function In SQL Server

  by SQLDenis on June 22, 2009

  functions howto sql server 2000 sql server 2008
• Writing reports off third party databases the easy way

  by Ted Krueger (onpnt) on June 5, 2009
• Compression tools are a must for any DBA

  by Ted Krueger (onpnt) on May 27, 2009
• SQL Server does support regular expressions in check constraints, triggers are not always needed

  by SQLDenis on May 26, 2009

  check constraints how to pitfall sql server tip
• Here Is Yet Another Reason For Upgrading To SQL Server 2008 From SQL Server 2000

  by SQLDenis on May 22, 2009

  sql server 2000 sql server 2008
• SMO Script Index and FK's on a database

  by Ted Krueger (onpnt) on May 18, 2009
• How to import a bunch of XML files from a directory in T-SQL

  by SQLDenis on April 28, 2009

  import sql server 2005 sql server 2008 xml
• Creating a Basic Drilldown Report in SSRS 2005

  by David Forck (thirster42) on April 27, 2009
• Split string in SQL Server 2005+ CLR vs. T-SQL

  by Ted Krueger (onpnt) on April 21, 2009
• Distance Calculation Showdown

  by Alex Ullrich on April 20, 2009
• Troubleshooting Performance Problems in SQL Server 2008 White Paper Released

  by SQLDenis on April 15, 2009

  performance sql server 2008 troubleshooting white paper
• Rule "Previous releases of Microsoft Visual Studio 2008" failed

  by ca8msm on April 9, 2009
• Use Joins, Not IN

  by Alex Ullrich on April 3, 2009
• Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax

  by SQLDenis on March 5, 2009

  integration services sql server 2005 sql server 2008 ssis xml
• How To Name Default Constraints And How To Drop Default Constraint Without A Name In SQL Server

  by SQLDenis on February 18, 2009

  best practice pitfall sql server 2000 sql server 2005 sql server 2008 tip trick
• SQL Server Distance Calculation Option 3 – Using the CLR

  by Alex Ullrich on February 18, 2009

  clr proximity search sql server
• An Interview With Kevin Kline About SQL In A Nutshell Third Edition

  by SQLDenis on February 4, 2009

  book interview mysql oracle postgresql sql server 2008
• SQL Server - Set based random numbers

  by George Mastros (gmmastros) on January 24, 2009
• What is wrong with this code?

  by SQLDenis on November 12, 2008

  coding sql server 2005 sql server 2008
• Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation

  by SQLDenis on September 18, 2008

  book data modeling database design interview sql server 2008
• How to get the selectivity of an index

  by SQLDenis on May 20, 2008

  database indexes optimizing sql sqlserver