FLOAT datatype casting issue
Do you use the FLOAT datatype? If so you had better read this……
Today I came across an issue somebody posted...
2013-02-01
5,152 reads
Reblog: January 25 to January 31
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-01
920 reads
A Month of PowerShell – Day 1 (Getting Started)
Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know...
2013-02-01
2,217 reads
Activating Windows 8 from MSDN
I installed Windows 8 recently and needed to activate it. I didn’t do this on the install since I didn’t...
2013-02-01
1,143 reads
Database Lifecycle Management for Azure SQL Database
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created...
2013-02-01
1,938 reads
Querying Execution Plan XML For Inaccurate Row Count Estimates
I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”.
I was amazed by the beauty...
2013-01-31
1,893 reads
SSRS 101 – Creating a Shared Data Source
In continuation with my previous post on Creating a SQL Server Reporting Services (SSRS) Project, you will now learn how...
2013-01-31
2,576 reads
AD FS Token Based Authentication In Code
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
433 reads
How to find/modify SQLServer Agent logfile location?
1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out
DECLARE @AGENT_ERRORLOG NVARCHAR(255)
EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,
N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,
N’ERRORLOGFILE’,
@AGENT_ERRORLOG...
2013-01-31
7,768 reads
Day 24 of 31 Days of Disaster Recovery: Handling Corruption in a Clustered Index
Welcome to day 24 of my 31 Days of Disaster Recovery series. Previously, I’ve talked about several different forms of...
2013-01-31
1,861 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers