Data We Don't Want
There's potentially an exploit that can download lots of data to a machine. This shouldn't be a concern for servers, but you never know.
2013-03-05
187 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
Come Learn at SQL Intersection, Get a Surface Tablet
This spring I’m speaking at the SQL Intersection conference. It’s a new conference, managed by SQLskills founders Kimberly Tripp and...
2013-03-04
1,187 reads
Data Loss
A new study shows potential corruption issues with solid state drives when power is cut under a load. That can have implications for data professionals as more databases incorporate SSD storage.
2013-03-04
145 reads
Why SQL Server?
This Friday Steve Jones asks you how you got started working with SQL Server in your career? Let us know how you got started and why you stuck with it.
2013-03-01
264 reads
Windows 8 – First Impressions on a Desktop
I bought a new (to me) desktop recently to replace my aging hardware. I’ve had a quad core machine, but...
2013-03-01
1,033 reads
More Evolution, More Complexity
As SQL Server advances and evolves, Steve Jones thinks it gets more complex, not necessarily easier to administer.
2013-02-28
120 reads
A Learning Experiment at SQL Saturday #187– Richmond
In a little over a week, SQL Saturday #187 takes place in Richmond, VA. I’m looking forward to going back...
2013-02-27 (first published: 2013-02-25)
1,142 reads
Attaching an MDF with no Log (AdventureWorks)
Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently...
2013-02-27
1,994 reads
The Microsoft Sideshow
Microsoft hasn't performed well on the stock market across the last decade, but the company has changed. There are cries that the business has been mismanaged and today Steve Jones has a few comments.
2013-02-27
162 reads
Look Beyond the First Result
As computer systems become more complex and dynamic, it's possible that the results we see might not be what we expect. Steve Jones talks about a situation with Orbitz.
2013-02-26
115 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
SQL Server Auditing: Track Changes by Specific Users on Specific Database Tables
Hello Everyone! My organization is looking to implement a solution in SQL Server (2019...
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...
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