Help Us Help You
SQLServerCentral has a new place for discussions and Steve Jones hopes you use it. It's a forum built for critiquing and discussion the presentations that the SQL Server community shares with each other.
2011-01-24
77 reads
Editorials
Is hyper-threading still relevant for SQL Server?
There still seems to be a lot of fear, uncertainty and doubt, in the community, with regard to use of Hyper-threading (HT) with SQL Server workloads. So, how and when should it be used?
2011-01-24
756 reads
Changing the Past
This Friday Steve Jones explores archived data. Can you restate past results or change old data? This week Steve Jones asks how data professionals feel about this and what guidance they give to their customers.
2011-01-21
118 reads
The Face of BI for SQL Server
Donald Farmer recently left Microsoft, and he will be missed, but Steve Jones knows that there will be new faces to get to know.
2011-01-20
194 reads
Skunk Works
The idea of a skunk works is to build a project that works under the radar, by a small and loosely organized group of people. Used to fuel innovation, this is an idea that you might apply to SQL Server BI projects.
2011-01-19
168 reads
Data Scientists
Would you want to be a data scientist? Are you one now? Steve Jones talks about this skill that we might appreciate in our daily work.
2011-01-18
417 reads
ETL Security Holes
The growth of ETL processes and secondary systems for reporting, decision support and other analysis creates an issue. Steve Jones points out that we ought to be remembering that security needs to be applied to data, not just systems.
2011-01-17
234 reads
The Spring Semester
SQL University is kicking off their spring semester, and Steve Jones is looking to motivate you to participate.
2011-01-17
72 reads
Scaling Up
Would you want to manage a VLDB? Or write the code for an application that uses one? This Friday Steve Jones asks the question of you.
2011-01-14
138 reads
Operating in Failure
Today we have an editorial from Sept 25, 2005 being republished as Steve is on vacation. This one talks about the need to expect failure in our systems and code for it.
2011-01-13
70 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
Import data from json file with special characters
I am using the following script to import data from a json file. This...
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers