Tracking Logins with Extended Events
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I...
2016-01-01 (first published: 2015-12-16)
4,164 reads
What Alerts Us About The SQL Agent? - Syndication – WaterOx Consulting
The SQL Agent is our friend! Setting up SQL Server Agent to automate jobs and alerts is a great idea....
2015-12-16
722 reads
Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3
I ran across a bug in SSMS 2016 CTP 2 back in August. If you try to right click and...
2015-12-16
453 reads
Scripting out multiple scripts from the Object Explorer Details window.
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what...
2015-12-16
603 reads
Indexing Strategy
What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...
2015-12-28 (first published: 2015-12-16)
3,582 reads
When Should You Use Identity as a Clustered Index Key?
A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be...
2015-12-28 (first published: 2015-12-16)
3,848 reads
Sentiment Analysis & Key Phrase Detection w/ Power Query & Power BI
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment...
2015-12-24 (first published: 2015-12-16)
2,390 reads
Which Secure Protocols are Allowed on Your Servers
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance. This one works well for local servers. If you...
2015-12-15
38 reads
Which Secure Protocols are Allowed on Your Servers
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance.
This one...
2015-12-22 (first published: 2015-12-15)
1,808 reads
Giving Thanks Around the Holidays
In the West, the holiday season summons different memories and plans for different people. The thought of gorging on a...
2015-12-25 (first published: 2015-12-15)
1,027 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 KCU YOGYAKARTA Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta...
Layanan BCA KCU PURWODADI Telp:0821°8200°233
Telp/Wa 628218200233 Jl. MT. Haryono No.2, Jengglong Timur, Purwodadi, Kec. Purwodadi, Kabupaten Grobogan, Jawa...
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