Free T-SQL Database Maintenance Scripts
I often get questions in e-mails, or at user group meetings, for advice on writing T-SQL database maintenance scripts. There...
2009-10-14
4,308 reads
SKUUpgrade =1 in SQL 2005
One of the things on my todo list for this past week was to upgrade a SQL 2005 Standard Instance...
2009-10-13
745 reads
Blogging
Hi,
Yesterday while talking to my friend, he reviewed my blog and suggested that I was having so many spelling...
2009-10-13
439 reads
Operations Manager Feedback
If you’re involved with maintaining Microsoft Operations Manager, you probably have a few things you’d like to tell the developers,...
2009-10-13
518 reads
Table Variables Are Only in Memory: Fact or Myth
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The...
2009-10-13
671 reads
SQL Server Legend – Data Files and Threads
Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...
2009-10-13
4,003 reads
SQLServerCentral Article on Database Space Capacity Planning
I wrote an article for SQLServerCentral entitled "Database Space Capacity Planning" that demonstrates a database and volume (disk) capacity planning solution...
2009-10-13
1,001 reads
PASS Update #15
We just had our October board meeting, this one ran the full hour and was a good discussion, catching up...
2009-10-12
230 reads
Afraid of Presenting? Try Toastmasters
I should be writing a technical post in the next day or so. I've been focusing more on the community...
2009-10-12
1,330 reads
SQL Server Lunch Milestone (100+ Attendees)
Today’s SQL Lunch was a huge success, even though we experienced a few technical difficulties. Tim Mitchell spoke on Deploying...
2009-10-12
776 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kantor Bank BCA KCP Lomanis Telp:08218154393
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers