Speaker of the Month: December 2015
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
453 reads
Blog Posts
Can we get a license for DDL Triggers?
There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...
2015-12-17 (first published: 2015-12-14)
1,693 reads
New Whitepaper – SQL Server Licensing Reduction
Poor storage performance continues to be the largest pain point with enterprise Database Administrators in today’s virtual world. However, it...
2015-12-17
1,077 reads
Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?
So two new exciting capabilities were announced recently in Power BI. One involved Excel and the other SSRS, but they...
2015-12-17 (first published: 2015-12-14)
1,851 reads
SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.
Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we...
2015-12-17
21 reads
What Permissions Does This Login Have?
I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer. Grant the login the same permissions...
2015-12-17
2,185 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
442 reads
Picking a Clustered Index
A Clustered Index is not another term for Primary Key, and more thought should be put into the key columns...
2015-12-16 (first published: 2015-12-14)
2,554 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
581 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
710 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
Rethinking How We Approach Assignment Help
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers