Putting a Database into Single User Mode
I was recently discussing with a group of budding DBA’s how you go about performing a restore of database. They...
2011-08-08
1,370 reads
Gethyn Ellis
Audit SQL Logins
Written by David Postlethwaite There are several ways that you can audit who has logged in to your SQL Server. The...
2011-08-05
4,816 reads
Updating Views
Written by Ian Treasure
Gethyn recently posted on deleting from a view. He used a common situation where several tables are...
2011-08-03
10,167 reads
We Have Another New Contributor…
I’d like to introduce you all to my friend Ian Treasure who has kindly volunteered to write some posts and...
2011-08-01
617 reads
Calling SCOM in C#
Written by David Postlethwaite
I’m sure there are many out there using System Centre Operations Manager (or SCOM for short)...
2011-07-29
3,982 reads
Searching for Wild Card Characters
I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses...
2011-07-27
785 reads
IT Professionals, the Job Search and the Killer CV
It has been while since I wrote anything on my contracting blog but over the past month or so I...
2011-07-25
1,219 reads
SSRS: Dynamic Data Sources
I have been building dashboard using Reporting Services (SSRS) for a client of mine. The dashboard is going to be...
2011-07-22
7,970 reads
DOS Batch File Date and Time
Written by David POstlethwaite
A non SQL blog for a change
Ever needed to create a batch file that wrote a time...
2011-07-20
1,389 reads
Execute Permissions
Written by David Postlethwaite
Security of the SQL database is becoming more and more important these days yet I’m finding that...
2011-07-18
14,469 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...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
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