Impersonating a server level permission
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,656 reads
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,656 reads
This script displays the last date and time of each backup type for each database.
It’s useful when you need to...
2014-02-26
513 reads
When I right click on the database diagrams folder in SSMS to create new diagram. Following popup window open with error.
Solutions:
From the Message you can clearly see that the...
2014-02-25
68 reads
There are two flavors of HDInsight: Windows Azure HDInsight Service and Microsoft HDInsight Server for Windows (recently quietly killed but...
2014-02-25
2,097 reads
Have you ever voted against something only to be glad later you got out voted? Too many years ago the...
2014-03-05 (first published: 2014-02-25)
1,497 reads
Deservedly so, I got called out for a bit of attitude I displayed in a recent blog post: Time for...
2014-03-06 (first published: 2014-02-25)
1,852 reads
I’ve had several instances over the last few months where I had to reinstall the SQL Server Performance Counters. It...
2014-03-04 (first published: 2014-02-25)
4,610 reads
Let's say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
3,667 reads
Damit auch alle, die vor 2 Wochen nicht auf der SQL Konferenz in Darmstadt (www.sqlkonferenz.de) waren, oder nicht regelmäßig bei...
2014-02-25
754 reads
Table with clustered index is totally depended on index accessibility.
ERROR : The query processor is unable to produce a plan because...
2014-02-25
5,121 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Comments posted to this topic are about the item Training the next generation
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers