Certificate Based Application Roles
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,590 reads
Blog Posts
Executing PowerShell in SQL Server Redux
A while ago I blogged about using xp_cmdshell to execute a PowerShell script in SQL Server and return a result...
2010-11-30
1,634 reads
Multiple Mirrors
Up through SQL Server 2008 R2 database mirroring has been limited to a single mirror for each database. While that...
2010-11-30
5,480 reads
NOLOCK – truth
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,505 reads
PASS Summit Magic: The Prestige
Ta-DA!!!!
So we started this show with the Pledge, got wowed with the Turn and finally we’ve come to the last...
2010-11-30
1,842 reads
Regressions
Hannah Dustin, Upset about Regression
One of the most important take-aways from David Dewitt’s presentation at the PASS Summit was the...
2010-11-30
1,629 reads
SQL Server Magazine’s Favorite Go-To Websites for SQL Server Solutions
While flipping through this month’s SQL Server Magazine (December 2010), I came across what I thought was a very interesting...
2010-11-30
3,968 reads
SSIS Package Annotation in Denali
If you are anything like me, you document your SSIS packages for those who may have to maintain them after...
2010-11-30
3,770 reads
Android Adventures–Part 2
I’ve been living with my Droid X phone for a couple weeks now. It’s definitely a big change from my...
2010-11-29
1,484 reads
Blog Round-up – What Are You Thankful For?
Last week I suggested to others that we institute a little idea theft and put together a few blog posts...
2010-11-29
2,209 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU RUNGKUT HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa Timur...
BCA KCU KEDIRI HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
BCA KCU GALAXY HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers