Download Analytic Platform System Tools and Books Online
Photo Credit – Mario KlingemannMicrosoft’s Analytic Platform System (APS) has been a favorite platform of mine over the last few years....
2015-11-20 (first published: 2015-11-17)
1,776 reads
Blog Posts
Python and Tweepy
One of the projects that’s been on my list lately is to programmatically access Twitter for a few ideas I...
2015-11-20
833 reads
Savepoints and conditional transactions
This is the second in a short series on transactions. In the previous part I discussed nested transactions and showed...
2015-11-20 (first published: 2015-11-17)
3,437 reads
Scripts – A Living History
As a DBA, I have a collection of scripts that I use for anything from auto-fixing logins to seeing who...
2015-11-20
981 reads
Aggregation Design is Back!
If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012...
2015-11-19
476 reads
Create a Whitelist for SQL Server
UPDATED - May 16, 2017 - Please review the updated code here.
In my previous post, Configuring the Azure SQL Database Firewall, I discussed...
2015-11-19 (first published: 2015-11-17)
2,554 reads
Get All Referenced Tables and Columns
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which was written many years ago by the guy who...
2015-11-19
29 reads
Get All Referenced Tables and Columns
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which...
2015-11-19
1,598 reads
How HADR_SYNC_COMMIT waits can wreak havoc
It has been a decade since I have blogged. Or at least it feels like it. Today I would like...
2015-11-19 (first published: 2015-11-17)
4,599 reads
Job & Process Documentation Tips
Three big things I look for in documentation:
Who to call when it goes wrongWhere to find it the code, especially...
2015-11-19
546 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 Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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