Variable Scope in SQL Server
The way variable scoping works in SQL Server has been well documented on MSDN, but I have seen related issues...
2013-01-18
2,839 reads
SQLWise
A really simple Multiprocessing Python Example
Purpose and introduction A Python program will not be able to take advantage of more than one core or more...
2012-12-21
4,769 reads
Playing with Cython
Intro Recently, I came over Cython and started experimenting with it. After some basic testing, I found several things of...
2012-11-23
1,201 reads
Class and instance variables in Python 2.7
The differences and interactions between class variables and instance variables are well described in the Python 2.x documentation, but they...
2012-10-06
2,373 reads
Some Jargon from the SQL Server World
Not long ago I wrote about how to write well about SQL Server, and one major point was that jargon...
2012-09-04
1,133 reads
The effects of an SSD on SQL Server Performance
I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...
2012-07-29
5,692 reads
New articles posted.
My article Plotting SQL Server Data for Data Visualization is up on MSSQLTips now and discusses using PyQt and Matplotlib...
2012-07-21
827 reads
Writing About SQL Server
I. Introduction I recently submitted my entry for a writing competition as part of my continuing education. While I was...
2012-07-09
1,433 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers