PASS Update #18
Eric Wisdahl posted some questions on my last update, and I thought I’d reply here to make my answers more...
TechNet Magazine - Oct Q&A
Unexpected Consistency Checks, Troubleshooting Memory Usage, More from Paul Randal.
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
Virtualization and Preparation
The DBA news of the week contains some interesting thoughts on DR and virtualization plans. Steve Jones comments on why you should care about these topics.
Characters
No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
The Query Optimizer: Date Correlation Optimisation
In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to anyone doing queries involving temporal data. For anyone doing Data Warehousing, timetabling, or time-based pricing, this could speed up your queries considerably. Who better to introduce this than Query Optimizer expert, Fabiano Amorim?
Troubleshooting Reporting Services
Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition. In this article, we will turn our attention to troubleshooting methods that can be employed to identify and resolve problems affecting reporting functionality and performance.
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCP Galuh Mas Telp:0818751777
WhatsApp:0818-751-777 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Alamat kantor BCA KCP Galunggung Telp:0818751777
WhatsApp:0818-751-777 Jl. Galunggung No.65 11 dan 65/A1, Gading Kasri, Kec. Klojen, Kota Malang, Jawa...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers