A Month of PowerShell – Day 6 (Exporting and Importing)
Welcome to Day 6 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-06
783 reads
Blog Posts
Configuring/Authenticating with Identity Server in C#
In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...
2013-02-06
501 reads
DBAs and the Dark Closet
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the...
2013-02-06
1,026 reads
Determining Filegroup for a Table
Have you ever needed to figure out which filegroup your tables are located within? If you had to do this,...
2013-02-06 (first published: 2013-01-29)
4,759 reads
EXECUTE, not required, but advisable.
The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...
2013-02-06
773 reads
Quick alert on servers which are not compliant for policies set using PBM
Last month I wrote about leveraging policy based management for regular DBA compliance checks. You can read that post here.
Policy based management(PBM) is indeed...
2013-02-06
802 reads
Speaking at the Business Analytics Conference, April 1-12 in Chicago
The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please...
2013-02-06
687 reads
Using SkyDrive at Work for Collaboration - A Quick Start Guide
It seems that many of my projects in the past year or so have required sharing files with external business...
2013-02-06
1,149 reads
A Month of PowerShell – Day 5 (Scripting – Putting it together)
Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-05
1,650 reads
Adding the Clustered Key To Your Nonclustered Index? Part 2
Of course, a rather obvious answer presents itself the next day. After reviewing the actual environment that my colleague was...
2013-02-05
713 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers