|
| | | 1st
SQLServerCentral Newsletter- How to Make Scalar UDFs Run Faster (SQL Spackle)
- SQL Saturday #161 - East Iowa
- PowerShell SMO: Just Writing Things Once
- Utilize SQL Server Storage Effectively
- Out of the Frying Pan Into the Fire
- Create_sp_help_revlogin_DB
| 2nd
SQLServerCentral Newsletter- An Alternative (Better?) Method to UNPIVOT (SQL Spackle)
- Issues Determining an Individual SQL Server User's Permissions
- The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit
- No Limits
- Padding function
| 3rd
SQLServerCentral Newsletter- RegexClean Transformation
- Targeted Index Performance Improvements
- The Copy Cat Poll
- BackUp_DBs.sql
| 4th
|
5th
Database Weekly | 6th
SQLServerCentral Newsletter- SQL Saturday #154 | St.Louis, MO
- Pushing SQL Alerts to Remote Server using PowerShell 2 and T-SQL
- How to Audit Login Changes on a SQL Server
- Code Reviews Must Be Brutally Honest
| 7th
SQLServerCentral Newsletter- SQL Saturday #162 - Cambridge, UK
- Utilize SQL Server Storage Effectively
- Optimizing tempdb configuration with SQL Server 2012 Extended Events
- Display data by fiscal year instead of calendar year
- Stupid Interviewer Tricks
- Count of Objects by Database on a Server
| 8th
SQLServerCentral Newsletter- The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit
- SQL Saturday #164 - Cleveland
- Working with SSIS Data Types
- Stairway to SQL PowerShell Level 1: SQL PowerShell Basics
- Wiggle Room
- Calculate alphabetic sequence
| 9th
SQLServerCentral Newsletter- SQL Saturday #167 - Columbus, GA
- SQL Server 2012’s Information on Parallel Thread Usage
- Removing the SQL Server Management Data Warehouse
- A Data Hub
- 2008 Index Rebuild using DMV
| 10th
SQLServerCentral Newsletter- Regular Expression Transformation
- TDE Setup and Administration Scripts
- Separate Accounts
- Print The Calendar 2
| 11th
|
12th
Database Weekly | 13th
SQLServerCentral Newsletter- Tell Us What You Think
- SQL Saturday #156 - Providence, RI
- Using DELETE CASCADE Option for Foreign Keys
- Using the Konesans File Watcher Task in SSIS to Process Data Files
- No Limits
- List of objects from particular schemas
| 14th
SQLServerCentral Newsletter- SQL Saturday #170 - Munich, Germany
- Utilize SQL Server Storage Effectively
- Getting Started with Master Data Services (MDS) In SQL Server 2012
- 11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines
- Milk
- Script to get an ordered list of all stored procedures with parameters
| 15th
SQLServerCentral Newsletter- SQL Saturday #157 - San Diego
- Implement Continuous Integration In Your Software Project
- PASS Data Architecture VC presents Louis Davidson on Designing for Common Problems in SQL Server
- Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config
- Red Gate’s new custom metrics site - with a little help from our friends
- Learning C
- Unattended Install with PowerShell
| 16th
SQLServerCentral Newsletter- SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages
- TDE and SQL Server Databases
- Marketing Data is Exploding
- Trim Left Char (for single words)
| 17th
SQLServerCentral Newsletter- Row Count Plus Transformation
- Tell Us What You Think
- REPLACE Multiple Spaces with One
- The Influence of the Cloud
- Defragment all indexes on Database
| 18th
|
19th
Database Weekly | 20th
SQLServerCentral Newsletter- SSIS Basics: Introducing Variables
- The 2012 SQLServerCentral/Exceptional DBA Awards Party at the PASS Summit
- Enforce business rules with indexed views and a two-row table
- SQL Saturday #155 - Lima
- Time Off
- Display Names and Locations of SQL Database Files and DB Owners
| 21st
SQLServerCentral Newsletter- How To Support Multiple SQL Server Package Configurations in SSIS
- Red Gate Software announces speaker line up for US SQL in the City tour
- Hierarchies in SQL, Part II, the Sequel
- SQL Saturday #169 - Denver
- Big Data Jobs
- Identify Unique Columns
| 22nd
SQLServerCentral Newsletter- SQLSaturday #160 - Kalamazoo
- Row Number Transformation
- Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause
- Make a Backup First
- Calculate Easter Date
| 23rd
SQLServerCentral Newsletter- Provisioning a New SQL Server Instance – Part Two
- SQL in the City - New York 2012
- Working with SQL Agent Durations
- Being Exceptional
- Drop a table and views
| 24th
SQLServerCentral Newsletter- Solving the SQL Server Multiple Cascade Path Issue with a Trigger
- Stairway to MDX - Level 2: The Ordinal Function
- SQL in Boston -- Red Gate Style
- Fix v. Create
- Get dependant Objects
| 25th
Database Weekly |
26th
| 27th
SQLServerCentral Newsletter- SQL Saturday #162 - Cambridge, UK
- Practical PowerShell for SQL Server Developers and DBAs – Part 1
- Stairway to Database Design Level 1: Data Elements
- SQL in the City - Austin 2012
- Ten Million Lines of Code
- SSRS Execution Log Queries
| 28th
SQLServerCentral Newsletter- Export images from a SQL Server Table to a Folder with SSIS
- SQL Saturday #167 - Columbus, GA
- AlwaysOn Availability Groups in SQL Server 2012
- Shadow IT
- A simple way to find some arguments
| 29th
SQLServerCentral Newsletter- The Seven Sins against T-SQL Performance
- Stairway to SQL PowerShell Level 3: Input and Output with PowerShell
- SQL in the City - San Francisco 2012
- Watch Your Mouth
- How to calculate the check digit for a UCC/EAN code
| 30th
SQLServerCentral Newsletter- Creating a heat map in Reporting Services
- SQL in the City - Chicago 2012
- Using nmap to scan for SQL Servers on a network
- The Personal Checksum
- Insertion Query Creation of a Table in Milliseconds
| 31st
SQLServerCentral Newsletter- SQL in the City - Boston 2012
- AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups
- Why is my transaction log full?
- Finding a Balance
- Job Running time/Interval precentage
| |
| | | | | | |
