Analyzing SQL Server Permissions
This article shows the steps to analyze SQL Server logins and permissions to ensure that there are no logins and users that exist who are have unnecessary access
2009-03-17
3,464 reads
Articles
Book Review: Murach's SQL Server 2008 For Developers
I received a review copy of Murach's SQL Server 2008 For Developers a couple months back and just finished up looking through it. In general I've always liked the style of the Murach books; short lessons that flow about as logically as you can do it when it often seems like you need to know it all to get anything done!
2009-03-17
1,782 reads
Make the 2009 PASS Summit Better: Offer Your Speaking Tips to Others
This year, I was asked to participate on the PASS Program Committee Management team as the “Speaker Manager.” One of my tasks is to create a Speaker’s Resource page on the SQLPASS.org website to aid speakers who want to submit session abstracts for the 2009 PASS Summit, which will be held in Seattle, WA from November 3 — 6, 2009.
2009-03-17
1,157 reads
Real-Time Tracking of Tempdb Utilization Through Reporting Services
SQL Server 2005 system views and Reporting Services are combined to break down tempdb utilization into its individual components in real time.
2009-03-16
9,331 reads
CONTROL SERVER vs. sysadmin membership
In a previous blog post on Detecting When a Login Has Implicit Access to a Database, I mentioned that having CONTROL SERVER rights means having implicit rights into the databases. Robert Davis posted a comment asking if there was a difference with respect to explicit permissions between being a member of the sysadmin fixed server role and having CONTROL SERVER rights.
2009-03-16
3,550 reads
Database Mirroring Automating Failover for Multiple SQL Server Databases With No Witness
If you don't have a witness server and your principal server goes, how do you make your mirror server the principal and bring all your databases online?
2009-03-16
2,921 reads
SQL Server Knockoffs
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
2009-03-16
551 reads
SQL Server Knockoffs
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
2009-03-16
568 reads
SQL Server Knockoffs
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
2009-03-16
819 reads
Using Operations Manager Reports to Validate Your Uptime
Operations Manager has a number of reports to help you monitor the uptime of your applications, but reporting can be difficult to learn until you understand all the different options, the different parameters possible, and the way the Operations Manager health model is structured. Firstly, you need a clear idea about the way that your organization defines 'uptime'. then you can start your reports from any of the views in the Monitoring tab, and then add or remove objects to get the report you need.
2009-03-16
1,539 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers