Free SQL Exam cram sessions from Microsoft.
G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...
2011-05-31
2,952 reads
Blog Posts
How to protect code written in Stored Procedure or User Defined Function?
Introduction
We have always
been wondering on how to protect/secure our t-sql code written in Stored
Procedures and UDF in shared hosting environment...
2011-05-31
13,250 reads
Identity Reseeding
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...
2011-05-31
2,456 reads
Speaking at 24 Hours in the Cloud
On June 1st GITCA will run a 24 hour round-the-world virtual event focusing on Cloud Computing. Please visit http://sp.GITCA.org/sites/24Hours for...
2011-05-31
1,607 reads
SQLSaturday #85 in Orlando!
It’s that time of year again, actually a little earlier than in previous years as we’ll be holding our fifth...
2011-05-31
1,500 reads
Start All Your Meetings in Pole Position
Let’s face it, a lot of us don’t enjoy attending meetings and can often find them to be a bit...
2011-05-31
1,837 reads
Taking It to the Extreme: SQLCLR and Parallelism - a NYC event coming soon!
Here’s another awesome SQL event coming to New York City. (Keep reading for your discount below!) It’s already getting hot...
2011-05-31
2,364 reads
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
2,805 reads
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the closest help documentation - the comments inside the Script...
2011-05-31
16 reads
Use Connections Properly in an SSIS Script Task
There are lots of scenarios in SSIS where you'd want to use a connection within a Script Task. Unfortunately, the...
2011-05-31
25,961 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 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,...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
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