Searching for Wild Card Characters
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses...
2011-07-27
785 reads
Some Common Disk Drives Compared
Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of...
2011-07-27
1,136 reads
Strengths Finder 2.0
I’ve made the commitment to read and review 12 books over 12 months as a part of continuous personal development....
2011-07-27
903 reads
NYC SQL Server User Group - this Thursday - SQL2K8 Audit Feature
Quick update. This Thursday, July 28, 2011 at the NYC SQL Server User Group at Microsoft HQ in NYC, SQL MVP...
2011-07-26
1,471 reads
Fastest row counting method
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...
2011-07-26
6,396 reads
Projects – Win Early
Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even...
2011-07-26
681 reads
My upcoming speaking engagements
A few days ago I had an interesting conversation on Twitter about my upcoming speaking
engagements. I really realized at this...
2011-07-26
799 reads
SQL Server, Chennai and Me
It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While...
2011-07-26
899 reads
Optimize a query by thinking out of the box
Recently I had to create a simple query to lookup a single row in a table containing ranges that do...
2011-07-26
635 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,047 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers