You don’t need to be a sysadmin
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,312 reads
SQLStudies
Ever wonder what that goofy query in the header means?
It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited...
2016-03-08
1,159 reads
How do I grant someone the ability to create a stored procedure?
The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s...
2016-03-11 (first published: 2016-03-02)
2,284 reads
Blogger questions: How often should I blog?
What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again)...
2016-03-04 (first published: 2016-02-29)
1,245 reads
Powershell script to create multiple SQL Server Connections
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is...
2016-02-24
1,003 reads
You are not logged on as the database owner or system administrator.
I had one of my developers ask me why he keeps seeing the following warning when he tries to modify...
2016-02-22
1,091 reads
Take caution when altering a column using TSQL
When developing in SQL Server you are eventually going to have to modify a column or two (at least). And...
2016-02-23 (first published: 2016-02-17)
3,959 reads
varchar(1) VS char(1)
The other day I made a somewhat flip coment on twitter. (I know, everyone is shocked right?)
varchar(1) Really? It’s...
2016-02-15
1,595 reads
Changing to simple recovery to clear the log.
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
567 reads
Impersonation can give you the wrong answer
I use impersonation all the time to let me see additional permissions information I can only get that way and,...
2016-02-08
463 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers