Working with Consultants
After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several...
2018-04-27
464 reads
How to get alerted anytime SQL Service is restarted?
You may and should have monitoring in place to monitor state of your servers, services, jobs, critical and not critical...
2018-04-27
802 reads
Top 5 Features of SysTools SQL LDF Recovery Software - Review
An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for viewing transaction log file of SQL Server 2016,...
2018-04-27
20 reads
Top 5 Features of SysTools SQL LDF Recovery Software - Review
An SQL Server Expert Thoughts : I would like to recommend my readers to use SysTools SQL LDF recovery software for...
2018-04-27
1,037 reads
Backup VisualSVN using PowerShell
Quick and easy backup for VisualSVN. Wraps the svnadmin.exe and performs a hotcopy of all repositories in the $source_path, dumping them to the $backup_path [crayon-5c98d5a77e81c224584330/]
2018-04-27
69 reads
2018-04-26
11 reads
SQL Server Advanced Aggregations Part 1 Grouping Sets
This post is part 1 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...
2018-04-26
113 reads
SQL Ops Studio extension development : Starting an adventure
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...
2018-04-26
1,198 reads
180 – Is It Time For A Turnaround?
What needs to change? The challenge to explore is are there things in your current day to day that needs...
2018-04-26
513 reads
SQL Server database Backup and Restore strategies
One of the most important roles of a database administrator is to constantly protect the integrity of the databases and...
2018-04-26
558 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers