The CONNECT permission
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...
2016-02-03 (first published: 2016-01-27)
2,216 reads
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...
2016-02-03 (first published: 2016-01-27)
2,216 reads
I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor...
2016-02-01 (first published: 2016-01-25)
1,493 reads
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...
2016-01-26 (first published: 2016-01-14)
7,079 reads
tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.
While at the...
2016-01-20
9,577 reads
TSQL Tuesday #74: Be The Change
Each month, on the first Tuesday of the month, the announcement for the blog...
2016-01-18 (first published: 2016-01-12)
1,519 reads
To the page
It’s not one of those things you have to do frequently but every now and again you need...
2016-01-18
534 reads
MSDTC is frequently required when using transactions within SSIS. And not just when you are connecting to two SQL Server...
2016-01-12 (first published: 2016-01-06)
3,231 reads
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do...
2016-01-06 (first published: 2015-12-30)
2,458 reads
It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell...
2016-01-04
439 reads
In any study of Data Types in SQL Server you are going to have to look at the various string...
2015-12-28
2,370 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers