Creating a recycle bin for SQL Server 2005\2008
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
2009-05-20
13,735 reads
Articles
Data Profiling Column Functional Dependency T-SQL
This article demonstrates Data Profiling Functional Dependency
2009-05-20
4,523 reads
Connectivity Options for Microsoft SQL Server 2008 Integration Services
This white paper provides an overview of the connectivity options that are available for SQL Server 2008 Integration Services.
2009-05-20
1,939 reads
Denver SQL Server User's Group
Come learn about advanced data modeling with Paul Neilsen and DMVs with Glenn Barry, Thur, May 21 in Denver. Steve Jones will attend as well.
2009-05-20
1,223 reads
Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
2009-05-20
82 reads
Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
2009-05-20
83 reads
Do You Have a Problem?
Is it easier to justify expenses fr a developer than an administrator. Steve Jones thinks it is.
2009-05-20
326 reads
SQL Injection - Why I Don't Think Parameterization is Enough
One of the main defenses touted against SQL injection attacks is to use proper parameterization at the application layer. But while this gets most of the cases, there are clearly examples where this alone fails. For instance, consider the stored procedure...
2009-05-20
3,948 reads
SQL Server user defined function to convert MSDB integer value to time value
In a recent tip I outlined a process for converting a date, stored as an integer into a datetime data type. Date and time information for run history of SQL Server Agent jobs is stored within the msdb..sysjobshistory table as an integer data type, not as a datetime as one would expect. As promised, this tip picks up where we left off. On converting the integer-typed run_time into a format that is more user friendly for presentation purposes.
2009-05-20
2,522 reads
2009-05-19
13,196 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers