SQLServerCentral Runs sp_Blitz - Security
A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.
2013-01-10
10,052 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
A Learning Experiment
I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but...
2013-01-09
1,161 reads
Statistical Protection
Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.
2013-01-08
106 reads
T-SQL Tuesday #38 – Standing Firm
It’s T-SQL Time again, and this time it’s #38, from Jason Brimhall (b | t | li). The topic this month is...
2013-01-08
1,185 reads
Full-Text Search – Stoplists in SQL Server
Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text...
2013-01-07 (first published: 2012-12-31)
6,531 reads
The $50,000 Laptop
The average value of a lost laptop has been found to be much more than you might expect. Steve Jones talks about a recent study.
2013-01-07
214 reads
The Default Fillfactor for an Index
I ran down the rabbit hole on transaction logs recently. I started with Paul Randal’s post over at the SQL...
2013-01-07
1,181 reads
DR Prep
This week Steve Jones asks how you might handle DR preparation or process differently in the new year.
2013-01-04
111 reads
Speaking at SQL Saturday #183 – Albuquerque
I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first...
2013-01-04
1,161 reads
All Flash
Should you think about using SSD storage in your SQL Server databases? Steve Jones thinks this might be something you should consider.
2013-01-03
215 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Experimental Verification of the NKTg Law on 8 Planets (NASA 2024 Data, SQL)
Nguyen Khanh Tung Email: traiphieu.com@gmail.com ORCID: 0009-0002-9877-4137 -------------------------------------------------------------------------------- Abstract This article presents a numerical...
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers