SQL Server Policy Based Management Alerts
SQL Server Policy Based Management Alerts
Problem
Policy-Based Management is used to enforce standards on SQL Servers and it's great. But not...
2012-12-04
4,358 reads
On the Advantages of DateTime2(n) over DateTime
Starting with SQL 2008, we database developers started becoming more familiar with datetime2. Sometimes folks need convincing though, so here...
2012-12-04
12,288 reads
Lost in Translation – Deprecated System Tables – sysprocesses
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-12-03
2,128 reads
Speaking at Oracle Training Days
A first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to...
2012-12-03
1,066 reads
Power View and Reporting Services
There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting...
2012-12-03
742 reads
Logins vs Users
Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....
2012-12-12 (first published: 2012-12-03)
3,720 reads
MDX #23 – “Hello World!” Lesson in MDX
Almost every tool we learned has some sort of “Hello World!” tutorial lesson.
So here comes the “Hello World!” lesson in...
2012-12-03
1,092 reads
T-SQL: CASE Statement
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...
2012-12-11 (first published: 2012-12-03)
5,190 reads
Last Weeks Top 10 “Reading” Links #9
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-03
1,025 reads
HDInsight, Finally
See this:
That’s right. The install worked. All I had to do was get a completely clean server set up. No...
2012-12-03
1,391 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 KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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