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.
Checking SQL Server Agent jobs using Windows PowerShell
Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?
Blogs
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers