Microsoft Sql Server

Posts (664 posts published)

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

  by Jes Borland on April 24, 2018
• Use ostress to load test a SQL database

  by Jes Borland on October 26, 2017
• I'm talking SQL Server, Azure, and Extended Events at SQLintersection

  by Jes Borland on August 18, 2016
• Learn more about Azure + SQL Server at SQLSaturday Minnesota

  by Jes Borland on August 15, 2016
• Announcing SQL Saturday Minnesota #557 Pre-Conference Seminars!

  by Paul Timmerman on July 21, 2016
• Testing SQL Server with an Application

  by Jes Borland on June 21, 2016
• Learn about SQL Server in Azure in Madison, WI

  by Jes Borland on January 27, 2016
• Prepare to Set Sail on SQL Cruise Caribbean 2016

  by Jes Borland on November 23, 2015
• Announcing SQL Saturday Minnesota #453 Pre-Conference Seminars!

  by Paul Timmerman on August 3, 2015

  #sqlsat453 #sqlsatmn Minnesota pre-cons sqlsaturday
• SQL Server 2016 CTP 2.1 has been released

  by Koen Verbeeck on June 29, 2015

  sql 2016 sql server syndicated
• My first SQL 2016 bug

  by Koen Verbeeck on June 29, 2015

  bug sql 216 sql server
• 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
• SQL 2016 Preview has been released!

  by Koen Verbeeck on May 28, 2015

  ctp2 sql server sql2016 ssis ssrs syndicated
• Solving a slow running query issue with UNION

  by Koen Verbeeck on February 25, 2015

  performance sql sql server syndicated t-sql
• Overview of Published Articles – 2014Q4

  by Koen Verbeeck on January 7, 2015

  mssqltips sql server ssas ssis ssrs syndicated
• Beware the defaults! (in windowing functions) – The Movie!

  by Koen Verbeeck on November 27, 2014

  online training sql server syndicated t-sql webucator windowing functions
• Overview of Published Articles – 2014Q3

  by Koen Verbeeck on October 24, 2014

  articles business intelligence sql server ssas ssis ssrs tips
• Beware the defaults! (in windowing functions)

  by Koen Verbeeck on October 7, 2014

  sql syndicated t-sql windowing functions
• The Magic Alt Button

  by Koen Verbeeck on September 23, 2014

  block selecting text sql sql server ssis syndicated tsql
• Split a Query Window in SSMS

  by Jes Borland on September 10, 2014
• Availability Groups Setup and Configuration from A to Z

  by Ted Krueger (onpnt) on June 4, 2014
• SSRS Nugget: displaying placeholders when no rows are returned

  by Koen Verbeeck on May 15, 2014

  business intelligence reporting services sql server ssrs syndicated
• Speaking at ITPROceed

  by Koen Verbeeck on May 14, 2014

  bi business intelligence data visualization itproceed reporting services sql server ssrs
• T-SQL Tuesday #54: An Interview Invitation

  by Koen Verbeeck on May 13, 2014

  interview sql server syndicated t-sql tuesday
• MDS: A Database Error Has Occurred

  by Koen Verbeeck on April 18, 2014

  batch error mds syndicated
• Changing the 1000 separator in Power View

  by Koen Verbeeck on March 11, 2014

  business intelligence formatting power bi power view sql server syndicated
• Dude, where's my Power Map?

  by Koen Verbeeck on February 26, 2014

  click-to-run office 2013 office 365 office service pack 1 power bi power map syndicated
• Calculating the length of a hash in SQL Server

  by Koen Verbeeck on February 11, 2014

  hash sql server ssis syndicated
• Master Data Services (Second Edition) – Review

  by Koen Verbeeck on January 31, 2014

  master data management master data services mds sql server 2012 syndicated
• T-SQL Tuesday #50: Automation, how much of it is the same?

  by Koen Verbeeck on January 14, 2014

  automate biml ssis syndicated tsql2sday
• 2013 – Review of Writing

  by Ted Krueger (onpnt) on January 2, 2014
• Can I recover from a secondary replica COPY_ONLY full backup?

  by Ted Krueger (onpnt) on December 11, 2013
• Async replica loss causes transactional replication to fail

  by Ted Krueger (onpnt) on November 29, 2013
• Create ETL solutions faster with metadata driven development – Session Materials

  by Koen Verbeeck on November 13, 2013

  biml speaking sql server sqlserverdays sqlug ssis syndicated
• Document Your SQL Server Databases with Extended Properties

  by Jes Borland on November 6, 2013
• Automated Job Activation with Mirroring and Availability Groups

  by Ted Krueger (onpnt) on November 5, 2013
• SQL Server Services fail to start – FAIL_PAGE_ALLOCATION

  by Ted Krueger (onpnt) on October 21, 2013
• Speaking about BIML at the SQL Server Days 2013

  by Koen Verbeeck on October 15, 2013

  biml speaking sql server sqlserverdays sqlug ssis syndicated
• Enable TDE when Replication is in use

  by Ted Krueger (onpnt) on October 10, 2013
• Replication requires the actual server name – Incorrect server name

  by Ted Krueger (onpnt) on October 9, 2013
• Unexpected result with the File System Task

  by Koen Verbeeck on October 9, 2013

  configurations create directory file system task ssis syndicated
• SQL Agent Job High Availability – Availability Groups

  by Ted Krueger (onpnt) on October 5, 2013
• SQL Server Configuration Manager – Remote Procedure Call Failed

  by Ted Krueger (onpnt) on September 11, 2013
• Virtual book club.. who is in?

  by SQLDenis on August 22, 2013

  book sql server
• SSIS Deployment with PowerShell: Adding Environment References

  by Koen Verbeeck on August 21, 2013

  catalog deployment powershell sql server ssis syndicated
• Rants about Connect

  by Koen Verbeeck on July 29, 2013

  connect microsoft powerpivot sql server ssas tabular ssrs syndicated
• SQL 2014 CTP1, where is my BIDS?

  by Koen Verbeeck on June 28, 2013

  bids ctp1 sql server 2014 sql server data tools ssdt ssdtbi syndicated
• Managing Transaction Log Growth

  by Ted Krueger (onpnt) on June 27, 2013
• Which loads faster – 2008, 2008 R2 or 2012

  by Ted Krueger (onpnt) on June 27, 2013
• Data Visualization Tips & Tricks – Slides

  by Koen Verbeeck on June 27, 2013

  dashboard data visualization sql server ssrs
• List of new programmability features/T-SQL enhancements in SQL Server besides Hekaton

  by SQLDenis on June 25, 2013

  hekaton sql server 2014
• 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
• SQL Server 2014 CTP1 Available for download

  by SQLDenis on June 25, 2013

  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
• Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site

  by Koen Verbeeck on June 12, 2013

  business intelligence demo environment excel power view powerpivot sharepoint 2013 sql server ssas ssrs syndicated
• Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services

  by Koen Verbeeck on June 11, 2013

  business intelligence demo environment excel power view powerpivot sharepoint 2013 sql server ssas ssrs syndicated
• Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration

  by Koen Verbeeck on June 10, 2013

  business intelligence demo environment excel powerpivot sharepoint 2013 sql server ssas syndicated
• Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint

  by Koen Verbeeck on June 7, 2013

  business intelligence demo environment excel powerpivot powerpivot configuration tool sharepoint 2013 sql server ssas syndicated
• Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint

  by Koen Verbeeck on June 6, 2013

  business intelligence demo environment excel powerpivot sharepoint 2013 sql server ssas syndicated
• 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.. Sorting results without using ORDER BY

  by SQLDenis on June 5, 2013

  puzzle sql server 2000 sql server 2005 sql server 2008 sql server 2012 teaser
• Building a SharePoint 2013 BI Demo Environment Part 5 – Installing SharePoint

  by Koen Verbeeck on June 5, 2013

  business intelligence demo environment sharepoint 2013 sql server syndicated virtual machine
• Building a SharePoint 2013 BI Demo Environment Part 4 – Installing SQL Server

  by Koen Verbeeck on June 4, 2013

  business intelligence demo environment sharepoint 2013 sql server virtual machine
• Building a SharePoint 2013 BI Demo Environment Part 3 – Installing the OS

  by Koen Verbeeck on June 3, 2013

  business intelligence demo environment hyper-v sharepoint 2013 sql server syndicated virtual machine windows server 2012
• Building a SharePoint 2013 BI Demo Environment Part 2 – Building the VM

  by Koen Verbeeck on May 31, 2013

  business intelligence demo environment hyper-v sharepoint 2013 sql server syndicated virtual machine
• Building a SharePoint 2013 BI Demo Environment Part 1 – Introduction

  by Koen Verbeeck on May 30, 2013

  business intelligence demo environment sharepoint 2013 sql server syndicated
• 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
• SQL Server Database owner ~~UNKNOWN~~

  by SQLDenis on May 14, 2013

  security sql server 2000 sql server 2005 sql server 2008 sql server 2012
• SQL Server Baseline Collection

  by Ted Krueger (onpnt) on May 7, 2013
• Fixing a SQL Server could not spawn FRunCM thread error

  by SQLDenis on April 30, 2013

  encryption error fix sql server 2005 sql server 2008 sql server 2012
• 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
• Force installation of 64-bit ACE OLE DB provider

  by Koen Verbeeck on April 23, 2013

  64 bit ace ole db excel run64bitruntime ssis syndicated
• Missing index suggestion – Duplicate Index

  by Ted Krueger (onpnt) on April 20, 2013
• Buffer Latch Error Restoring SQL Server Database

  by Ted Krueger (onpnt) on April 10, 2013
• Using a Dedicated Administrator Connection via SSMS

  by SQLDenis on April 7, 2013

  dac how to sql server 2008 sql server 2012
• How I prepared myself for the MCSE certification

  by Koen Verbeeck on April 4, 2013

  business intelligence certification mcsa mcse microsoft syndicated
• BCP all tables into files from a database

  by SQLDenis on March 31, 2013

  bcp bulk export bulk import data migration
• Little used SSIS tasks: Data Profiling Task

  by SQLDenis on March 28, 2013

  ssis
• Bring SQL Server databases Online or Offline when running on Amazon RDS

  by SQLDenis on March 22, 2013

  amazon web services aws cloud rds
• 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
• Setting up Mirroring to SQL 2012 Availability Groups Encryption Error

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

  by SQLDenis on March 20, 2013
• Red Gate Releases SQL Backup Pro 7.3

  by Ted Krueger (onpnt) on March 20, 2013
• 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
• Triggers affect on SQL System Variables

  by Kevin Conan on March 12, 2013

  rowcount identity sql trigger
• Use the sp_describe_undeclared_parameters stored procedure to check if dynamic SQL has undeclared parameters

  by SQLDenis on March 6, 2013
• Standardize Table Aliases

  by Sam Vanga on March 5, 2013
• SSMS – Enabling Ctrl+R Shortcut to show or hide query results/messages pane

  by Kevin Conan on March 4, 2013

  ssms
• 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
• Stupid me #2 – Where is my SSIS package executed?

  by Koen Verbeeck on February 28, 2013

  dtexec executed on different server ssis ssis service
• An easier way to get SQL Server startup parameters: the sys.dm_server_registry dmv

  by SQLDenis on February 24, 2013

  dmv dynamic management view registry sql server 2012 startup options
• 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
• 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
• SQL Server Licensing for Non-Production

  by Kevin Conan on February 14, 2013

  licensing sql server
• When is DTEXEC installed?

  by Koen Verbeeck on February 12, 2013

  dtexec installation integration services service sql server ssis
• An Oracle NULL/Blank gotcha when coming from SQL Server

  by SQLDenis on February 10, 2013

  gotcha null oracle sql server tip
• Discovering new things (for me) in SSMS

  by SQLDenis on February 10, 2013

  sql server 2005 sql server 2008 sql server 2012 sqlcop ssms tables
• SQL Server Support Windows Phone App released

  by SQLDenis on February 9, 2013

  mobile sql server 2000 sql server 2005 sql server 2008 sql server 2012 windows phone
• Listing all your SQL Server databases ordered by size

  by SQLDenis on February 8, 2013

  databases sql server 2000 sql server 2005 sql server 2008 sql server 2012 sqlcop
• 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
• Leveraging MSBUILD to automate SSRS deployments – session material

  by Koen Verbeeck on February 5, 2013

  automate deploy deployment msbuild pass sqlug ssrs
• 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
• 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
• Slow source? Make your data flow buffers smaller!

  by Koen Verbeeck on January 30, 2013

  buffer data flow defaultbuffermaxrows defaultbuffersize performance tuning sql server ssis
• Define Microsoft Business Intelligence for me?

  by Ted Krueger (onpnt) on January 29, 2013
• When do statistics update?

  by Ted Krueger (onpnt) on January 28, 2013
• A Glance of Plan Explorer Pro's Deadlock Analysis

  by Ted Krueger (onpnt) on January 28, 2013
• Driving Predictive Analytics

  by Ted Krueger (onpnt) on January 23, 2013
• Do not disable foreign keys

  by Ted Krueger (onpnt) on January 23, 2013
• Script to Populate Date Dimension, without Using a Cursor

  by Sam Vanga on January 22, 2013

  data warehouse
• SQLUG.be meeting: Automating SSRS Deployments

  by Koen Verbeeck on January 22, 2013

  automate deploy deployment pass sqlug ssrs
• Database Designing With Performance In Mind

  by Ted Krueger (onpnt) on January 22, 2013
• Why avoiding multiple code blocks in a Stored Procedure

  by Axel Achten (axel8s) on January 21, 2013

  case if else procedure cache t-sql
• The OLE DB Source and the Oracle Date Literal

  by Koen Verbeeck on January 21, 2013

  ansi date literal ole db source oracle ole db provider pl/sql ssis
• Import Wizard – Microsoft.ACE.OLEDB 12.0 provider is not registered

  by Ted Krueger (onpnt) on January 19, 2013
• Creating statistics manually – Duplicate Statistics

  by Ted Krueger (onpnt) on January 19, 2013
• 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
• 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
• Stupid me #1 – Locking myself out of SQL Server

  by Koen Verbeeck on January 15, 2013

  default database locked out sa account sql server
• 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
• Getting started with Execution Plans

  by Axel Achten (axel8s) on January 10, 2013

  execution plan query plan
• Giving users the ability to change a stored procedure without making them db_owner

  by SQLDenis on January 8, 2013

  dcl permissions security sql server 2008 sql server 2012 stored procedures
• Database Projects – Installing the Database Project Template

  by Axel Achten (axel8s) on January 8, 2013

  database lifecycle database projects sql server datatools ssdt
• T-SQL Tuesday #38 – Resolving an SSIS package performance problem

  by Koen Verbeeck on January 8, 2013

  performance tuning ssis t-sql
• Truncate rollback differences between SQL Server and Oracle

  by SQLDenis on January 6, 2013

  gotcha oracle sql server tip truncate
• What is the Dual table in Oracle and why do I need it?

  by SQLDenis on January 6, 2013

  gotcha oracle sql server tip
• Differences between Oracle and SQL Server when working with NULL and blank values

  by SQLDenis on January 6, 2013

  gotcha null oracle sql server tip
• Why you shouldn't use SELECT *

  by Axel Achten (axel8s) on January 2, 2013

  select select star t-sql
• SHOW_STATISTICS Density showing key column – Why?

  by Ted Krueger (onpnt) on December 31, 2012
• 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
• 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
• Creating a Semi-additive Measure over a Parent-child Hierarchy

  by Koen Verbeeck on December 17, 2012

  mdx parent-child hierarchy semi-additive ssas
• 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
• Database Projects – Setting up Source Control

  by Axel Achten (axel8s) on December 11, 2012

  ankhsvn database lifycycle database project sql server sql server data tools ssdt subversion
• Update Table Based on a JOIN

  by Ted Krueger (onpnt) on December 11, 2012
• T-SQL Tuesday #37: Join me in a month of Joins

  by Koen Verbeeck on December 11, 2012

  joins oracle sql server t-sql tuesday
• SQL Server Query Tuning – Back to Basics

  by Ted Krueger (onpnt) on December 9, 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
• My SQL Server Days slides and demos

  by Koen Verbeeck on December 3, 2012

  cdc change data capture sql server days ssis
• 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
• Utilizing SQL Server Reports from SSMS

  by Ted Krueger (onpnt) on November 28, 2012
• 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
• What's the deal with Excel & SSIS?

  by Koen Verbeeck on November 27, 2012

  ace ole db excel imex=1 jet ole db ssis syndicated typeguessrows
• 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
• Hello World

  by Koen Verbeeck on November 23, 2012

  business intelligence sql server ssis
• Expert Performance Indexing for SQL Server 2012 for $15

  by Ted Krueger (onpnt) on November 20, 2012
• 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
• Book Review: SQL Server Hardware

  by Jes Borland on October 22, 2012
• SELECT * vs SELECT 1 with EXISTS

  by Ted Krueger (onpnt) on October 18, 2012
• Removed Replication – rowguid added back

  by Ted Krueger (onpnt) on October 18, 2012
• SSMS Add-in for Plan Explorer Update

  by Ted Krueger (onpnt) on October 17, 2012
• Plan Explorer Pro – First Glance

  by Ted Krueger (onpnt) on October 15, 2012
• Why does sys.dm_exec_requests not show my SPID?

  by Ted Krueger (onpnt) on October 12, 2012
• Adding nonclustered index on primary keys

  by Ted Krueger (onpnt) on October 11, 2012
• Full outer join requires some thinking before use

  by Christiaan Baes (chrissie1) on October 10, 2012

  full outer join sqlserver
• Why you should register for SQL Server Days 2012

  by Axel Achten (axel8s) on October 9, 2012

  belgium sql server sqlserverdays training
• 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
• SQL Saturday #160 — To each end, a beginning

  by joshuafennessy on September 30, 2012
• T-SQL Window Functions – Part 4: Analytic Functions

  by Steve Hughes (DataOnWheels) on September 25, 2012
• T-SQL Window Functions – Part 3: Aggregate Functions

  by Steve Hughes (DataOnWheels) on September 17, 2012
• T-SQL Window Functions – Part 2: Ranking Functions

  by Steve Hughes (DataOnWheels) on September 11, 2012
• T-SQL Window Functions – Part 1: The OVER Clause

  by Steve Hughes (DataOnWheels) on September 6, 2012

  order by over partition by window function
• Plan Cache effects when dropping columns

  by Ted Krueger (onpnt) on September 4, 2012
• T-SQL CASE functions

  by Axel Achten (axel8s) on September 3, 2012

  case choose coalesce iif isnull sql server 2012 t-sql
• Free SQL Server Tools

  by Jes Borland on August 31, 2012
• LOB Logical Reads twice the row count

  by Ted Krueger (onpnt) on August 28, 2012
• Migrating Replication Subscribing Databases

  by Ted Krueger (onpnt) on August 9, 2012
• Index Seek on LOB Columns

  by Ted Krueger (onpnt) on August 8, 2012
• SQL Server 2008 R2 SP2 Released

  by SQLDenis on July 27, 2012

  service pack sql server 2008 r2 support
• SQL Saturday Indy – Invasion of SSIS

  by Ted Krueger (onpnt) on July 26, 2012
• Merge Replication Baseline Collector

  by Ted Krueger (onpnt) on July 18, 2012
• Row Overflow Pages – Index Tuning

  by Ted Krueger (onpnt) on June 28, 2012
• Balanced Data Distributor for SSIS 2012 Released

  by Ted Krueger (onpnt) on June 20, 2012
• T-SQL Tuesday #31 – Logging Simple Things

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

  sql server t-sql
• Does updating a column to itself get logged? #TSQL2sday 31

  by Ted Krueger (onpnt) on June 12, 2012
• T-SQL Tuesday #31 – Reporting Services Logs

  by Jes Borland on June 12, 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
• Catching the OUTPUT of your DML statements

  by Axel Achten (axel8s) on May 25, 2012

  audit log output clause
• 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
• Report Builder 3.0 – Report Parts

  by Jes Borland on May 11, 2012
• 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
• SQL Server Developer Tips and Tricks

  by David Forck (thirster42) on April 23, 2012
• Using EXECUTE AS OWNER

  by Ted Krueger (onpnt) on April 19, 2012
• I'm a Radio Star! I'm Talking SSRS on RunAs Radio

  by Jes Borland on April 18, 2012
• Finding Exact Duplicate Indexes

  by George Mastros (gmmastros) on April 12, 2012
• Columnstore Index – Index Statistics

  by Ted Krueger (onpnt) on April 10, 2012
• Columnstore Index Basics

  by Ted Krueger (onpnt) on April 9, 2012
• Please don't use blacklists, use parameterized queries or stored procs instead

  by SQLDenis on April 5, 2012

  best practices security sql injection
• 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
• Contained Databases, Temporary Tables and Collations

  by Axel Achten (axel8s) on March 27, 2012

  collation contained database tempdb temporary table
• How to give permissions to User-Defined Table Types

  by SQLDenis on March 21, 2012
• Another reason to show off your Tech – Happy Pi()

  by Ted Krueger (onpnt) on March 14, 2012
• Grouping and merging data with CROSS APPLY

  by Axel Achten (axel8s) on March 12, 2012

  cross apply for xml merging columns sql server
• Database Mirroring Deprecated in 2012

  by Ted Krueger (onpnt) on March 8, 2012
• Report Builder 3.0 – Chart Types, Visualizations, and Properties

  by Jes Borland on March 8, 2012
• Merge Replication – COM Based Resolver throws Buffer too small Error

  by Ted Krueger (onpnt) on March 6, 2012
• CozyRoc Releases SSIS+ 1.6 Beta

  by Ted Krueger (onpnt) on March 2, 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
• SQL Server Installation Error – Consistency validation for SQL Server Registry keys

  by Ted Krueger (onpnt) on February 16, 2012
• Report Builder 3.0 – The Introduction

  by Jes Borland on February 15, 2012
• Merge Replication – Filtered Data Publication Setup

  by Ted Krueger (onpnt) on February 14, 2012
• Row-Level and Column-Level tracking in Merge Replication

  by Ted Krueger (onpnt) on February 14, 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
• MERGE bug when Foreign Key constraint is created on non-clustered index (2008RTM)

  by niikola on February 10, 2012

  merge sql server sql server 2008
• 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
• Convenient ad-hoc bcp table loading

  by Erik on February 4, 2012
• Automating Index Statistics Collection with SSIS – The fast one

  by Ted Krueger (onpnt) on January 27, 2012
• Take advantage of Database Mirroring in your applications

  by Ted Krueger (onpnt) on January 24, 2012
• Estimating Mean Uptime for Team-based uptime measurements

  by Ted Krueger (onpnt) on January 23, 2012
• January #Meme15 Assignment – Twitter, the Blog, taking over the universe

  by Ted Krueger (onpnt) on January 16, 2012
• 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
• WiSSUG "Filegroups: Putting the Pieces Together" Materials

  by Jes Borland on January 11, 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
• Performance Impacts of Unicode, Equals vs LIKE, and Partially Filled Fixed Width

  by Eli Weinstock-Herman (tarwn) on December 28, 2011
• 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
• Troubleshooting Merge Replication Performance – Indexing Publications

  by Ted Krueger (onpnt) on December 14, 2011
• 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
• T-SQL Tuesday #25: T-SQL Tricks – Checking Transaction Log Space Used

  by Jes Borland on December 13, 2011
• Troubleshooting Merge Replication – Logging

  by Ted Krueger (onpnt) on December 12, 2011
• 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
• Red Gate's new SQL Index Manager

  by Ted Krueger (onpnt) on December 8, 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
• Location of files for new database in SQL Server

  by SQLDenis on November 17, 2011

  data files files log files sql server 2005 sql server 2008 sql server 2012
• 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
• You should be watching

  by David Forck (thirster42) on November 9, 2011
• 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
• SSMS Assembly Error – Microsoft.SqlServer.Sqm.dll

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

  by Ted Krueger (onpnt) on October 26, 2011
• Database space use

  by David Forck (thirster42) on October 24, 2011
• A New Door Opens

  by Jes Borland on October 24, 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 Saturday #92 Portland, OR: Wrap-Ups, High-Fives, and Doughnuts

  by Jes Borland on October 17, 2011
• SQL Server 2012 to be released Q1 2012

  by SQLDenis on October 12, 2011

  denali sql server 2012
• 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 Iowa another success!

  by Ted Krueger (onpnt) on October 6, 2011
• A New Adventure: Tech On Tap

  by Jes Borland on October 5, 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
• Using T-SQL OUTPUT and MERGE To Link Old and New Keys

  by Eli Weinstock-Herman (tarwn) on September 13, 2011

  merge output t-sql
• 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
• Red Gate SQL Toolbelt Review

  by David Forck (thirster42) on August 8, 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
• 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
• 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
• 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
• 2011 Quarter 2 Goal Review

  by Jes Borland on July 1, 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
• Energizing the Next Generation: A Women In Tech Discussion at SQL Saturday #75

  by Jes Borland on June 15, 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
• SQL Server Filegroup Piecemeal Restores

  by Jes Borland on May 24, 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
• SQL Server DBA Tip 15 – SQL Server Agent – Job ownership

  by Ted Krueger (onpnt) on May 16, 2011
• SQL Server DBA Tip 14 – SQL Server General – Updating Production Data

  by Ted Krueger (onpnt) on May 13, 2011
• SQL Server DBA Tip 13 – SQL Server built in DR/HA Solutions

  by Ted Krueger (onpnt) on May 12, 2011
• SQL Server DBA Tip 12 – SQL Server Tuning – Missing Index DMV

  by Ted Krueger (onpnt) on May 11, 2011
• Transaction Log: VLF's, Auto Growth and Performance

  by SQLArcher on May 11, 2011
• SQL Server DBA Tip 11 – SQL Server Configuration – MIN Memory

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

  by Jes Borland on May 10, 2011
• SQL Server DBA Tip 10 – SQL Server Reporting – Offload the reporting factor

  by Ted Krueger (onpnt) on May 9, 2011
• Removing OS Files Through a Stored Procedure

  by SQLology ~ Kim Tessereau on May 7, 2011
• SQL Server Database Administration Tip a Day Series

  by Ted Krueger (onpnt) on May 6, 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
• Presenting for PASSMN May 17th

  by Ted Krueger (onpnt) on May 6, 2011
• SQL Server DBA Tip 9 – SQL Server Monitoring – Default Trace

  by Ted Krueger (onpnt) on May 6, 2011
• SQL Server DBA Tip 8 – Server Monitoring – Baseline

  by Ted Krueger (onpnt) on May 5, 2011
• SQL Server DBA Tip 7 – Server Security and grouping – Schema Control

  by Ted Krueger (onpnt) on May 4, 2011
• Compressing Data with Uniqueidentifier columns

  by Ted Krueger (onpnt) on May 3, 2011
• SQL Server DBA Tip 6 – Server Security – Windows Authentication / SQL Authentication

  by Ted Krueger (onpnt) on May 3, 2011
• SQL Server DBA Tip 5 – Server Considerations – Installing Features (SSIS, SSRS, Engine, SSAS)

  by Ted Krueger (onpnt) on May 2, 2011
• BI Interview Questions....

  by SQLology ~ Kim Tessereau on May 1, 2011
• SQL Server DBA Tip 3 – Server Configuration – Model Database

  by Ted Krueger (onpnt) on April 28, 2011
• SQL Server DBA Tip 2 – Server Configuration – Data/Log Files

  by Ted Krueger (onpnt) on April 27, 2011
• SQL Server DBA Tip 1 – Server Configuration – MAX Memory

  by Ted Krueger (onpnt) on April 26, 2011
• Spatial Data From Your iPhone

  by Brian Davis on April 26, 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
• Observing – Optimize for Ad Hoc Workload server option

  by SQLology ~ Kim Tessereau on April 9, 2011
• 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
• Compress Data Partition Snapshots with SSIS – SQL University

  by Ted Krueger (onpnt) on April 7, 2011
• Think about your presentation and who reviews it

  by Ted Krueger (onpnt) on April 6, 2011
• SQL University – Performance Week

  by Ted Krueger (onpnt) on April 5, 2011
• Use a database how it was intended to be used

  by SQLDenis on April 4, 2011

  design normalization
• Meme Monday: Eleven Words or Less

  by Ted Krueger (onpnt) on April 4, 2011
• Using STOPAT in the RESTORE DATABASE Statement

  by Jes Borland on April 4, 2011
• SQL Saturday Fun

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

  by SQLology ~ Kim Tessereau on April 3, 2011
• My Experience Attending a Free-Con

  by Jes Borland on March 31, 2011
• Wow what a week in review.....

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

  by Ted Krueger (onpnt) on March 30, 2011
• SQL Saturday #67 Chicago 2011 Wrap-Up

  by Jes Borland on March 28, 2011
• SQL Saturday in Chicago 2011 Eval

  by Ted Krueger (onpnt) on March 27, 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
• SQL University Women In Technology (WIT) Week - My Name Is Jes, and I'm a WIT

  by Jes Borland on March 7, 2011
• New Collection of SQL Server Videos on Channel 9

  by SQLDenis on March 5, 2011

  denali howto sql server 2008 r2 videos
• Creating Mailing Labels in SQL Server Reporting Services

  by Jes Borland on February 28, 2011

  mailing labels sql server reporting services ssrs
• 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
• Changing a SQL Server Database Owner

  by Jes Borland on February 15, 2011
• 24 Hours of PASS, WIT Edition: Register! Learn! Listen to Me!

  by Jes Borland on February 14, 2011
• 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
• SQL University – SQL Server Reporting Services: Exploring the RSReportServer.config File

  by Jes Borland on February 3, 2011
• Using Database Snapshot As A Protection Against Rogue Deletes

  by SQLDenis on February 2, 2011

  delete snapshot sql server 2005 sql server 2008
• SQL University – SQL Server Reporting Services Configuration Files Overview

  by Jes Borland on February 1, 2011
• Backup file contents with SSIS – INSERT/UPDATE Decisions

  by Ted Krueger (onpnt) on January 31, 2011
• Backup file contents with SSIS – Supporting tables and procedures

  by Ted Krueger (onpnt) on January 28, 2011
• Adding External Tools to SQL Server

  by David Forck (thirster42) on January 27, 2011
• Backup file contents with SSIS – Foreach Loop Container and file handling

  by Ted Krueger (onpnt) on January 25, 2011
• Backup file contents with SSIS – Defining the Design

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

  by ptheriault on January 20, 2011
• First glance at the new Red Gate SQL Monitor

  by Ted Krueger (onpnt) on December 30, 2010

  performance red gate sql monitor sql server
• Using RMO to run replication tasks

  by Ted Krueger (onpnt) on December 30, 2010

  replication rmo sql server 2008
• Policy-Based Management for SQL Agent History

  by Ted Krueger (onpnt) on December 28, 2010

  policy-based management sql server 2008
• Running older compatibility levels in newer versions

  by Ted Krueger (onpnt) on December 28, 2010

  database administration sql server 2008 sql server upgrade
• Procedure expects parameter error from SqlCommand

  by Ted Krueger (onpnt) on December 27, 2010

  .net c# slqcommand sql server
• 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
• Tapping Into Your Reporting Services Database

  by David Forck (thirster42) on November 19, 2010

  reporting services sql server 2005 sql server 2008 sql server 2008 r2 ssrs t-sql
• 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
• PASS Summit is upon us

  by Ted Krueger (onpnt) on October 19, 2010

  pass sql server 2008 sql server community
• SQLCop behind a Proxy

  by Ted Krueger (onpnt) on October 18, 2010

  best practices sql server 2008 sql server community sqlcop
• What exactly is Fragment_count?

  by Ramireddy on October 16, 2010
• 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
• Security Auditing a Database

  by David Forck (thirster42) on October 8, 2010
• 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
• 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
• Performance implications using NewID() in Random order

  by Ramireddy on September 15, 2010
• 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 Microsoft.Ace and OPENROWSET Errors

  by remou on September 2, 2010
• 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: 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
• 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
• 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
• 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
• Delete all data in database (when you have FKs)

  by niikola on May 21, 2010
• 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
• 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
• Table sizes

  by niikola on February 18, 2010
• Mirroring: Witness misconceptions in High-Performance

  by Ted Krueger (onpnt) on February 16, 2010

  high availability mirroring sql server 2008
• 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
• A Little XML Can Go a Long Way

  by Alex Ullrich on January 15, 2010
• 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
• Beginning stages of a DR plan for SQL Server

  by Ted Krueger (onpnt) on November 13, 2009
• OUTER JOIN order

  by chopstik on November 12, 2009
• SSRS 05 Passing Multi-Value Parameters Between Reports.

  by David Forck (thirster42) on November 12, 2009
• Best Practice: Coding SQL Server triggers for multi-row operations

  by SQLDenis on November 12, 2009

  how to sql server 2000 sql server 2005 sql server 2008 tip triggers
• Best Practice: Do not cluster on UniqueIdentifier when you use NewId

  by George Mastros (gmmastros) on November 12, 2009
• SSRS 2005 Matrixes

  by David Forck (thirster42) on November 11, 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
• 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
• Don't start your procedures with SP_

  by George Mastros (gmmastros) on November 4, 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
• Using a Calendar for a Date Hierarchy Parameter with SSAS 2008 and SSRS 2008

  by riverguy on September 2, 2009
• 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
• SQL Server 2008 R2 August Community Technology Preview (CTP) Announced

  by SQLDenis on August 10, 2009

  business intelligence gemini madison sql server 2008 r2
• 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
• Including an Aggregated Column's Related Values

  by Erik on July 18, 2009
• IsNumeric, IsInt, IsNumber

  by George Mastros (gmmastros) on July 15, 2009
• How to get data out of Microsoft Dynamics Great Plains

  by David Forck (thirster42) on July 10, 2009
• by David Forck (thirster42) on July 10, 2009
• 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
• How to search for all words inclusive without using Full Text search

  by Naomi Nosonovsky 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
• SQL Server Decode/Encode unicode data

  by George Mastros (gmmastros) on July 8, 2009

  unicode
• Automatically create a SQL Server table in a new database.

  by George Mastros (gmmastros) on July 3, 2009
• 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
• 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
• Multi-Value Parameters in SSRS

  by Erik on May 22, 2009

  escape commas multi-value parameter split sql server ssrs
• 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
• Using one Parameter for Multiple Datasets in Reporting Services

  by Ted Krueger (onpnt) on May 11, 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
• Add Report Wizard Layout Style (Standard Company Style)

  by Ted Krueger (onpnt) on April 14, 2009
• Rule "Previous releases of Microsoft Visual Studio 2008" failed

  by ca8msm on April 9, 2009
• SQL Server 2008 sp1 Download

  by Alex Ullrich on April 8, 2009
• SQL Server: When 8000 Characters Is Not Enough

  by Erik on April 6, 2009
• Use Joins, Not IN

  by Alex Ullrich on April 3, 2009
• Show message for SSRS reports that do not return data

  by Ted Krueger (onpnt) on April 2, 2009
• Client Statistics in SSMS. Check execution times

  by Ted Krueger (onpnt) on March 22, 2009
• Optimizing with indexing where commonly overlooked

  by Ted Krueger (onpnt) on March 22, 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
• SQL Server 2008 Proximity Search With The Geography Data Type

  by SQLDenis on February 11, 2009

  geography geomapping spatial data sql server 2008
• SQL Server Zipcode Latitude/Longitude proximity distance search

  by George Mastros (gmmastros) on February 11, 2009
• Suppress string or binary data would be truncated messages with the ANSI WARNINGS setting

  by SQLDenis on February 9, 2009

  sql server 2000 sql server 2005 sql server 2008 tip trick
• SQL Server covering indexes

  by George Mastros (gmmastros) on February 4, 2009
• 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
• Altering the Schema of a stored procedure in SQL-server 2005

  by Christiaan Baes (chrissie1) on January 6, 2009
• Calculating Mean, Median and Mode with SQL Server

  by George Mastros (gmmastros) on December 22, 2008
• Extracting numbers with SQL Server

  by George Mastros (gmmastros) on December 12, 2008
• SQL Server Rounding Methods

  by George Mastros (gmmastros) on December 11, 2008
• SQL Server Case/When Data Type problems

  by George Mastros (gmmastros) on December 4, 2008
• SQL Server Fibonacci Sequence

  by George Mastros (gmmastros) on December 2, 2008
• SQL Server Precision And Scale Problems

  by George Mastros (gmmastros) on November 24, 2008
• Setting a standard DateFormat for SQL Server

  by George Mastros (gmmastros) on November 20, 2008
• 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
• Good SQL Articles To Read If You Can't Afford Books

  by SQLDenis on May 23, 2008

  database deadlocks functions howto math sql sqlserver tips toread tricks
• How to get the selectivity of an index

  by SQLDenis on May 20, 2008

  database indexes optimizing sql sqlserver
• Find the last Backup taken in SQL Server

  by Christiaan Baes (chrissie1) on May 17, 2008
• Do automated restore tests on your SQL-Backups.

  by Christiaan Baes (chrissie1) on May 17, 2008