Query Active Directory Data from SQL Server using T-SQL
Learn how to use SQL Server Transact SQL with OPENROWSET and OPENQUERY commands to access and retrieve data from Active Directory.
2009-12-09
5,402 reads
Additional Articles
Best Practice for renaming a SQL Server Database
One of the Junior SQL Server Database Administrator in my company approached me yesterday with a dilemma. He was assigned a task to rename few of the databases in Beta and Production environments; the reason being the database name was based on some other project that is no longer relevant to the data which is presently stored within the database. At first I started to tell him, but figured it would be smarter to document the same and share the information.
2009-12-08
6,195 reads
Databases in the Cloud: Elysian Fields or Briar Patch?
The cornucopia of products for handling distributed data in the cloud includes everything from lightweight key-value stores to industrial-strength databases
2009-12-07
2,186 reads
Understanding SQL Server fixed server roles
I know there are fixed server roles that come with SQL Server. How do I best use them within my installations? What should I watch out for?
2009-12-04
5,135 reads
Explore filtered models in SQL Server 2008
This articles explores how you can work with filtered models, a powerful new feature introduced in SQL Server 2008 that allows you build models on slices of a mining structure.
2009-12-03
2,607 reads
SQL Server Encryption Symmetric vs. Asymmetric Keys
I need to encrypt my data within SQL Server and I plan on using the built-in encryption functionality in SQL Server 2005 and 2008. However, I'm looking at symmetric and asymmetric key algorithms and while I see information saying to use symmetric keys, I don't understand why. What's the difference between the two and why is a symmetric key algorithm preferred over the asymmetric key ones?
2009-12-02
3,414 reads
Keeping Track of Virtual Databases
Are your database servers not performing well? Have you discovered two or more virtual servers running on the same node? Shailesh Khanal shows you how to generate a status report for multiple database servers and services, schedule it to run automatically and send it out via email.
2009-12-01
2,555 reads
SQL Server Integration Services (SSIS) - Troubleshooting Best Practices
In the previous tips (SQL Server Integration Services (SSIS) - Best Practices - Part 1 and Part 2) of this series I briefly talked about SSIS and a few of the best practices to consider when designing SSIS packages. Continuing on the same rhythm I am going to discuss some more best practices for SSIS package design, how you can design high performing packages with parallelism, troubleshooting performance problems etc.
2009-11-30
3,785 reads
How to simulate transparent data encryption (TDE) with SQL 2000 and 2005
Encryption of data at rest is becoming more and more crucial in today’s world. This tip is aimed to help businesses that do not have the budgets or resources to purchase hardware encryption tools or to upgrade to SQL 2008. It basically illustrates how to achive transparent file encryption with SQL 2005 or SQL 2000.
2009-11-27
4,390 reads
Increase Your Value as a Professional in the Technical Industry
It has never been so important to enhance your employability as it is today. Job security can never be taken for granted. Employability, increasing your professional value, means far more than just collecting qualifications, as Dr Masha Petrova explains: It also involves communicating, writing, and participating in communities.
2009-11-27
2,850 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers