T-SQL: Performance of SQL Agent Duration Calculations
In my article published yesterday on using Powershell for SQL Durations (Working with SQL Agent Durations), I proposed using a...
2012-08-24
1,644 reads
Mentoring
I’m putting my money where my mouth is, with respect to my last blog post. I am officially a mentor...
2012-08-24
656 reads
Government and Transparency
I ran across this report that talks about the effectiveness of transparency requirements put in place around the Recovery Act...
2012-08-24
659 reads
Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended...
2012-08-24
2,174 reads
Intel Haswell-EP Processor Rumors
Intel releases a new processor microarchitecture every two years, which is called a Tock release. One year later, they take...
2012-08-23
1,791 reads
Man Vs Machine
Man Vs Machine
Man Vs Machine
Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In...
2012-08-23
1,089 reads
Script to find orphaned/unreachable job steps within your SQL jobs
SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created...
2012-08-23
2,641 reads
SQL Server 2005 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements....
2012-08-23
1,108 reads
Transparent Data Encryption (TDE) with Database Mirroring
Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...
2012-08-23
1,760 reads
Tips For Minimizing Deadlocks in SQL Server
Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...
2012-08-23
2,494 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU YOGYAKARTA Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta...
Layanan BCA KCU PURWODADI Telp:0821°8200°233
Telp/Wa 628218200233 Jl. MT. Haryono No.2, Jengglong Timur, Purwodadi, Kec. Purwodadi, Kabupaten Grobogan, Jawa...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers