New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,743 reads
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,743 reads
Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many...
2012-02-27
1,442 reads
Why We Follow Best Practices
Best Practices
There are many reasons why we follow best practices. My own reasons have changed over...
2012-03-05 (first published: 2012-02-26)
3,602 reads
In a varchar column some of the entries were showing space in the left side and even after using the...
2012-02-26
9,168 reads
For the past six months or so I’ve hosted a daily status meeting for a large project. It started out...
2012-03-02 (first published: 2012-02-26)
2,030 reads
Thanks to the organizers and volunteers for making SQL Saturday #108 an overwhelming success. I’m just wrapping up the day...
2012-02-26
745 reads
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...
2012-02-26
928 reads
Today’s script will execute DBCC LOGINFO for all user databases. This is a script I use to monitor the number...
2012-02-25
2,658 reads
Today’s script is to help replication performance. It was something I learned from my resident replication expert Paul Anderton. Below...
2012-02-25
3,557 reads
This post explains how to list Event Log Messages with Powershell Get-EventLog , on multiple servers and output the results to...
2012-02-25
2,042 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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