PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,265 reads
John Sansom
PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy...
2014-01-14
137 reads
What’s the Best Path to Becoming a DBA?
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2014-01-07
1,569 reads
What’s the Best Path to Becoming a DBA?
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. I only...
2014-01-07
9 reads
DBA JumpStart – A SQL Community Ebook for DBAs
If you could give a DBA just one piece of advice, what would it be?
I asked 20 successful and experienced...
2013-12-16 (first published: 2013-12-10)
3,311 reads
DBA JumpStart – A SQL Community Ebook for DBAs
If you could give a DBA just one piece of advice, what would it be? I asked 20 successful and experienced SQL Server professionals this exact question. You can...
2013-12-10
6 reads
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.
Those rather nice...
2013-10-30
1,349 reads
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit...
2013-10-30
1 reads
Win a Free Conference Pass to SQL Server Live! in Orlando
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional.
Courtesy...
2013-10-21
601 reads
Win a Free Conference Pass to SQL Server Live! in Orlando
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional. Courtesy SQL Server Live! I’ve got an outstanding opportunity for...
2013-10-21
1 reads
Blogs
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Build a Serverless Todo App With AWS, Pulumi, and Python
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Forums
SQL Clustered Resource in online pending for about 3-5 mins before coming online
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
SQL Query to use in MS SSRS server to give you your report structure.
Code that can be used in order to create dashboard or SSRS report on...
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers