Theoretical Performance Issue Handling
Theoretical performance issue handling or handling theoretical performance issues from new author R. C. van Dijk.
Two Factor Authentication
SQL Server doesn't support two factor authentication, but Steve Jones thinks it might be a good idea. Perhaps it's something that will get implemented in the next version, and might even serve to better secure the platform.
Attaching a database in Microsoft SQL Server 2008
Various methods of using the "For Attach" clause exist to overcome the limitations that face us when using sp_attach_db and sp_attach_single_file_db. The first installment illustrates the use of the "Create Database" statement for the "For Attach" and "for ATTACH_REBUILD_LOG" arguments, for a single .MDF file and single .LDF file.
Reporting Services System and Item Security
Recent installments of our series have focused on SQL Server 2005 Express Edition's implementation of the Reporting Services component. This article addresses our temporary disregard of security restrictions by describing authentication and authorization functionality that can be leveraged to control access to published content and management characteristics.
Two Factor Authentication
SQL Server doesn't support two factor authentication, but Steve Jones thinks it might be a good idea. Perhaps it's something that will get implemented in the next version, and might even serve to better secure the platform.
Two Factor Authentication
SQL Server doesn't support two factor authentication, but Steve Jones thinks it might be a good idea. Perhaps it's something that will get implemented in the next version, and might even serve to better secure the platform.
Two Factor Authentication
SQL Server doesn't support two factor authentication, but Steve Jones thinks it might be a good idea. Perhaps it's something that will get implemented in the next version, and might even serve to better secure the platform.
Guide to MCITP: SQL Server 2008 Developer
An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.
Protection Close To Home
For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.
Back to basics: Optimizing SQL Server indexes
When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers