Using SMO Transfer Class to Script Database Objects
I’ve spent some time trying to get the SMO Transfer class to bend to my will. I want to script...
2011-07-25
5,021 reads
Building or Buying a High Performance, Low Cost Desktop Machine for SQL Server Development and Testing
There was a lengthy discussion on Twitter this morning, where one of my friends, Grant Fritchey (Twitter) was asking the...
2011-07-24
1,757 reads
South Florida IT Camp Presentation
Presentation and scripts from my Storing Powershell Output session at the South Florida 2011 IT Camp:
2011-07-24
620 reads
Lookup functions in SSRS 2008 R2 - I
Introduction
Most of us who are regularly working with SSRS have always felt the need of some way through which multiple...
2011-07-22
35,041 reads
SQLSaturday Orlando 2011 Call For Speakers Closes July 24
The 2011 version of SQLSaturday Orlando (officially SQLSaturday #85), a joint effort between Orlando's PASS chapters OPASS and MagicPASS, is...
2011-07-22
593 reads
I’ve Got A “SQLSat” In Kalamazoo
Last night I received an e-mail letting me know that I’ll be presenting at SQL Saturday #84 in Kalamazoo, MI. ...
2011-07-22
540 reads
Dynamically generate current Year, Month or Date member with MDX
MDX can be extended with Visual Basic functions like the FORMAT() and NOW() functions to dynamically generate the current year, month or...
2011-07-22
2,560 reads
Visual Studio vNext
“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio.
A big feature is improving the application lifecycle management...
2011-07-22
734 reads
SQLSkills Immersion training in London
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,267 reads
Re-blog – July 15-July 21
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-07-22
629 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