Get Just The Tools: SSMS Download
Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools. For some reason,...
2013-05-15
952 reads
SSAS – Find Cube Database Name, Size,Status and Total Size of SSAS Server
We are planning to take SSAS cube database backup since our backup tool does full file system backup in case...
2013-05-15
10,880 reads
Not My Google Reader Replacement
Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign...
2013-05-15
829 reads
Object Qualification
I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...
2013-05-22 (first published: 2013-05-15)
2,764 reads
Email Response: SQL Server 2012 Planning and Architecture
I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although...
2013-05-15
626 reads
CREATE SCHEMA can do what?!?!?
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,139 reads
Job Schedules – SQL Agent
This info should be easier to get than it is. Keep in mind that for something to run the subscription...
2013-05-15
1,320 reads
Roll Logs – Backup Recovery
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
2013-05-20 (first published: 2013-05-15)
2,037 reads
Table Sizes
There’s no simple way in SQL Server to see the sizes of all the tables and their indexes. Even seeing...
2013-05-15
670 reads
Index Columns and Names
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,544 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers