The Vacation Struggle
It can be hard to take all your time off each year and Steve Jones is in that situation right now. However he reminds us that life is more important than work.
Security for SQL Server User Defined Data Types
I have a group of developers that I support and they are reporting they cannot see columns within their tables. I have granted them db_datareader permissions which is a standard at my company for QA environments. Why can't they see their column definitions? Check out this tip to learn more.
Dynamically Truncate a Partitioned Table
Wouldn't be great if you could truncate any partition of a partitioned table with one T-SQL statement? This article shows you how.
SQL Server: How Important Are Index Statistics
In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.
An Automated Process to Archive Big Tables
Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database.
Programming
Programming is an important skill, perhaps extremely important for the future. Steve Jones thinks that's true.
Understanding SQL Server Query Optimization Statistics
In this article, you will learn what query optimisation statistics are and how SQL Server query optimizer uses statistics. You will also learn how to create and manage statistics, and what are the different ways to determine when statistics were last updated in SQL Server.
Reporting on Data
Reporting is an important skill for many data professionals. Steve Jones has a few things you might consider working on as a data professional.
SQL Saturday #230 Rheinland
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jul 13 2013 at Grantham-Allee 20, Sankt Augustin, Cologne/Bonn, Rheinland, 53757 , Germany.
Identify and Correct SQL Server Forwarded Records
Forwarded records in SQL Server can cause performance issues on heap tables because the record outgrows the page and the database engine uses pointers to reference the data. The best practice is to have a clustered index on every table, however, sometimes there are cases when a clustered index is not needed.
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 Kantor Bank BCA KCP Lomanis Telp:08218154393
WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa...
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
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