MDX #21 – Days in a month
ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods
ParallelPeriod() function is often used...
2012-11-22
1,375 reads
MDX #20 – Last Data Date
Need to check the last time when our ETL processes ran successfully
Data warehouse developers routinely query the last data date...
2012-11-22
676 reads
Notes from SQLSaturday #168 in Tampa
I made a quick trip to Tampa for #168 this past weekend. It was a “BI Edition” and it felt...
2012-11-21
949 reads
Explore file physical structure - Delete
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB...
2012-11-27 (first published: 2012-11-21)
1,765 reads
Lost in Translation – Deprecated System Tables – sysusers
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,786 reads
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012 Mickey Stuewe (sqlmickey) Neil Hambly (neil_hambly) Bob Hovious Gail Shaw (sqlinthewild) Ed Watson (SQLGator) ...
2012-11-21
12 reads
Most Interesting People…
Here are the most interesting people I met at PASS Summit 2012
Mickey Stuewe (sqlmickey)
Neil Hambly (neil_hambly)
Bob Hovious
Gail Shaw (sqlinthewild)
Ed Watson...
2012-11-21
1,449 reads
How to Use xp_delete_file to Purge Old Backup Files
Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to...
2012-11-21
4,541 reads
Lost in Translation – Deprecated System Tables – syspermissions
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-21
1,117 reads
Final 2012 Learning Opportunity
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,120 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