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,783 reads
Articles
Data Profiling Column Functional Dependency T-SQL
This article demonstrates Data Profiling Functional Dependency
2009-05-20
4,568 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,267 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
How have you encouraged communication at work?
I do have a question. At work, some groups of people have an inordinate...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers