SQL Saturday #352 - Sydney
SQL Saturday is coming to Sydney, Australia on October 25, 2014. Join us down under for a free day of SQL Server training and networking. Register while space is available.
Automate Yourself to a Coffee Break
A DBA should be working to automate their tasks, and find time to do things that are really important. Like keeping their coffee cup topped off 🙂
Premature Optimisation
Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.
Watson Freemium
IBM has released a free version of its Watson service to help people perform analytics on their data.
Prevent Confidential Data at the Application Layer from getting into SQL Server
In this tip Tim Smith looks at different approaches to stop confidential data from getting into the database.
Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".
No Compelling Reason
Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.
A TDD Journey: 3- Mocks vs. Stubs; Test Frameworks; Assertions; ReSharper Accelerators
Test-Driven Development (TDD) involves the repetition of a very short development cycle that begins with an initially-failing test that defines the required functionality, and ends with producing the minimum amount of code to pass that test, and finally refactoring the new code. Michael Sorens continues his introduction to TDD by implementing the first tests and introducing the topics of Test doubles; Test Runners, Constraints and Assertions.
Data Mining Part 17: Working with Reports
In this chapter, we will learn how to create Data Mining Reports using Reporting Services.
Data Mining Part 17: Working with Reports
In this chapter, we will learn how to create Data Mining Reports using Reporting Services.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers