SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,877 reads
Blog Posts
Red Gate Has 10th Birthday
I first met Simon Galbraith, one of the co-owners of Red Gate Software at PASS in 2002, when they had...
2009-10-24
409 reads
Another Year, Another Missed PASS Summit
This year I was really looking forward to going to the PASS Summit. It's worth every penny in the knowledge you'll...
2009-10-23
1,667 reads
Download the Free eBook “The SQL Server Tacklebox”
Rodney Landrum, SQL Server MVP, is the author of the new book, The SQL Server Tacklebox: Essential Tools and Scripts...
2009-10-23
584 reads
Just Submitted Session for South Florida Code Camp
I can’t wait until Feb 27 when Code Camp is right in my backyard! I just submitted my session for...
2009-10-23
362 reads
Not Pointing Fingers - Microsoft and Sidekicks
Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They...
2009-10-23
810 reads
PASS Summit One Week Away
It’s just a week and a couple of days before I’ll be hopping a plane for Seattle and the 2009...
2009-10-23
587 reads
Some useful commands and sp for Transaction Replication
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,544 reads
Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,337 reads
SQLLunch – Accidental DBA and Performance Data Collector
If you haven’t had a chance to attend the SQL Lunch Live Meeting learning series then sign in Monday at...
2009-10-23
876 reads
Blogs
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers