Five Virtual Labs for the SQL Server 2012 DBA
Wouldn’t it be nice if you had a chance to try out the features of SQL Server? Maybe give them...
2013-03-01 (first published: 2013-02-21)
4,286 reads
Presentation Materials “What Are You Waiting For?”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of...
2013-02-21
567 reads
Get Perfmon data with Powershell
Sometimes you just want to have a look at the system performance, or you feel tired with log on the server, open...
2013-02-21
2,153 reads
I’m presenting at the PASS SQL Saturday in Chicago
I have been selected to present at the SQL Saturday in Chicago on April 13th. This works out nicely as the...
2013-02-21
964 reads
A Month of PowerShell – Day 21 (Backups)
Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-28 (first published: 2013-02-21)
2,615 reads
Configure MOSS without GUI || Database name without additional GUID || PSCONFIG command to configure MOSS
Friends, do every time we need the GUI ? or we feel the need of Customized things some times in life....
2013-02-21
1,153 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 8: Sequence Clustering
by Steve Bolton
In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we...
2013-02-21
2,046 reads
MDX #26 – SSN can only be referenced as a member property in MDX
I’ve blogged about the Properties() function before.
MDX #11 – How to get number of cars each customer owned using Properties() function?
MDX...
2013-02-28 (first published: 2013-02-21)
1,975 reads
Windows 2012 for the DBA Setting Your Server to High Performance
Hello Dear Reader! I’ve been doing a lot of work with Windows Server 2012 lately. The interface is wildly different...
2013-02-27 (first published: 2013-02-20)
3,550 reads
A Month of PowerShell – Day 20 (Databases: Table-Valued Functions)
Welcome to Day 20 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-26 (first published: 2013-02-20)
2,763 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