SQL Server Schema Backups
- Posted in:
- SQL Server
- Database Administration
Options for backing up SQL Server database schemas
[...Read More]PowerShell Equality Comparison Operators
- Posted in:
- Development
- PowerShell
Why Be Normal?
[...Read More]
PowerShell Variables and Scope
- Posted in:
- Development
- PowerShell
PowerShell variables can live longer than you want them to, and hinder your development efforts too.
[...Read More]
PowerShell Functions and Return Types
- Posted in:
- Development
- PowerShell
The OutputType for a PowerShell function is useless.
[...Read More]
A Faster PIVOT for SQL Server?
- Posted in:
- Development
- JSON
- SQL Server
- T-SQL
Can the performance of PIVOT be beaten with newer T-SQL features?
[...Read More]Analytic Function FIRST_VALUE
- Posted in:
- Development
- SQL Server
- T-SQL
Return the first value in an ordered set of values with analytic function FIRST_VALUE.
[...Read More]NBA Games Are Harder Than Ever To Watch
- Posted in:
- NBA
The NBA's most valuable asset has been devalued. And it's the fans who pay the price.
[...Read More]
T-SQL Tuesday #135: Outstanding Tools
- Posted in:
- T-SQL
Tools of the trade that make my job awesome.
[...Read More]
Microsoft Certifications: an Evolving Stance
- Posted in:
- Azure
- Career
- Certification
- Microsoft
- SQL Server
Why I'm not as gung-ho about Microsoft certifications as I used to be.
[...Read More]
Adding Custom Transact-SQL Code Snippets
- Posted in:
- Development
- SQL Server
- SSMS
- T-SQL
How to add a custom Transact-SQL code snippet to SQL Server Management Studio.
[...Read More]