Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Change the Report Manager logo
A common question I've been asked a lot lately is how to replace the icon in the Report Manager to...
Controlling Execution Plans with Hints
The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best possible. You can give the Query Optimiser a better idea by using Table, Join and Query hints. These come with a risk: Any choices you force on the Optimizer by using hints can turn out to be entirely wrong as the database changes with the addition of data over time. Grant Fritchey, in a chapter from his highly acclaimed book, explains further.
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Networking One Tweet at a Time
Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
Should DBAs have local administrator rights?
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
Using the SQL Server Analysis Services (SSAS) Deployment Wizard
I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?
Limit Your Data Liability
We aren't necessarily liable for data breaches at our company, but will that last forever? Steve Jones talks about some things that you might want implement to ensure that you aren't liable if there ever is a security issue.
Microsoft Business Intelligence Project Booster Kit
Booster Kit for project involving SSIS / SSAS / SSRS
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
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...
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...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
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