More Can Come From Less
Becoming a more productive employee should be a goal for most people. It can also greatly increase the enjoyment you get from your career. Steve Jones gives you some ideas that might help you.
Take a Seat
Bill Nicolich raises questions about the chairs we sit in all day as technology professionals.
Trouble printing out long VARCHAR(MAX) strings?
Ever try to print out a long VARCHAR(MAX)/NVARCHAR(MAX) string, only to find that it's truncated at 8,000/4,000 characters? How do you get around this? New author Sam Bendayan shows us how.
HTTP 404 Not Found with Reporting Services and Windows 7
Here are some steps to fixing an issue I ran into with Window 7 and Reporting Services 2008. The problem was when I attempted to access the Report Server or Report Manager from my browser I received the error HTTP 404 Not Found.
Searching Unidentified Tables and Columns for Specific Content
You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns.
Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)
There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations.
Curacao SQL Server User Group
A new PASS chapter is now on the island of Curacao. Roy Ernest, longtime SQLServerCentral contributor, runs it. Come support this chapter in the Caribbean.
Using SP Configure - SQL School Video
Learn how you can configure your SQL Server instance using T-SQL code and sp_configure. MVP Andy Warren hosts this SQL School video.
Virtualization Hints
More and more people are looking at virtual servers, but it's not as simple as just installing the software. Steve Jones has a few comments about virtual database servers and what you can do for a successful project.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers