Transaction Logging & Recovery (101)
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
465 reads
Book Review 2015
It’s been a few years since I wrote a review of books I’ve read, so this isn’t going to list...
2016-01-15 (first published: 2016-01-05)
1,728 reads
Powershell Saturday in Tampa on March 19th, 2016
I was interested/intrigued to see that we’ll have a Powershell Saturday on March 19th in Tampa. This will be the...
2016-01-05
630 reads
One Note is the new WordPad
For all those still using Microsoft Word to take memos, prepare templates for email, preparing to do lists or even...
2016-01-05
985 reads
Transaction Logging & Recovery (101)
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
288 reads
A day in the Stream
Explore the little function called sys.fn_MSxe_read_event_stream and discover just a little bit more of what Extended Events may be doing behind the scenes with the live data viewer.
Related Posts:
Quick...
2016-01-05
34 reads
A day in the Stream
Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the...
2016-01-05
3,863 reads
2015 in review
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2016-01-04
340 reads
Monday Morning SQL Break – January 4, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-04
446 reads
Query the Buffer Pool
SQL Server's buffer pool is a majority of your memory, but most DBAs can't tell you what's in it.
2016-01-04
31 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