Indigestible is not a word commonly used with computer software. Perhaps it is time to add another definition to this adjective of the English language. As a database professional you will quickly see the value. adjective (of food) difficult or impossible to digest too complex or awkward to read or understand easily. “a turgid and indigestible book” I suggesting we […]

One reason an SQL database is chosen for data persistence is the ability to have ACID transactions (If you are not familiar with the acronym ACID you can do a Google search for more details). Not all applications require ACID capabilities, nor do all data engines provide ACID capabilities. There is a lot of overhead required to assure a transaction […]

I received some interesting feedback on my editorial, “Write Polite SQL”. . There were a couple questions asking why you might even use the concept in the first place? The questions were reasonable based on the example I provided. It was too simple, and other techniques, such as a filtered index, were better solutions (as suggested by A.J. Jim).Today I […]

Here is a tip for those learning to write inline views in SQL. When you write SQL it doesn’t hurt to be polite. Ok, now I’ve lost you. Let me explain. An inline view is when you write a SQL Statement and then use it as input in another SQL Statement. For this reason it is called an inline view. […]

Tomorrow kicks off our Spring Virtual Conference. The SSWUG Virtual Conference has evolved over time – no including information about different cloud bits, but of course different versions of SQL Server and different platforms. The Spring event is no exception. We have speakers from Microsoft, IBM, Idera and Datavail. Presentations from MVPs, authors, bloggers, and more. It’s an incredible gathering […]

Today I was watching a Channel 9 presentation regarding the future of C#, specifically new things coming in version 7. There were a few things that made an impact I wanted to communicate. One big thing that came out was the intentional separation of paths between the Dot Net language capabilities. No longer are they attempting to build everything into […]

Today I heard the phrase “Insensible Loss” on a local radio program. It was coined by a medical doctor. He defined Insensible Loss as the loss a person experiences without awareness through their natural senses. For example, we constantly breathe. We inhale and exhale air, while not sensing the exchange. How do you know it happens? You can observe your […]

Next week we’ll be opening the doors to the Spring 2016 SSWUG Virtual Conference. We’ll be bringing all the greatest speakers directly to you – watch from your office, from home, whatever works best for you. I’ve seen some of these session materials already – there are going to be some amazing presentations. From how-to, to developer to administrator to […]

Dynamic SQL being sent to an SQL Server database isn’t necessarily a bad thing. In fact, it need not even be slower than using a stored procedure. Moreover, it need not be susceptible to SQL Injection, where users coopt your SQL Statements to execute their own queries. This capability is easiest to explain using ADO.Net. To use dynamic SQL safely, […]

Database Pools on SQL Azure, although not completely released, are rapidly gaining adoption in the market. The technology is solid, and I would guess that the core functionality is not even new. Primarily, it is a new pricing and load balancing model, allowing database applications to take financial advantage in the ebb and flow of database utilization. In summary, you […]