Contents tagged with sql server
-
'Application cannot be started' running SQL Server Reporting Services Report Builder
SQL Server Reporting Services delivers its Report Builder as a click-once application when you click on the 'Report Builder' icon in the toolbar of the web application, unfortunately sometimes it " …
-
SQL Operations Studio, what is it and why should I use it?
Since the availability of a preview version of SQL Operations Studio (SOS, for short) was announced in November last year, It's been forever on my to-do list to download and take a look. Like …
-
Setting up SQL Server Reporting Services to use HTTPS/SSL
By default SQL Server Reporting Services (SSRS) sets itself up to respond to requests over HTTP made to the name of the machine that it's been installed on. Changing this up so that it can be …
-
Have you ever created a SQL Server login and left 'Enforce password policy' checked by mistake?
There are three little checkboxes that are ticked by default when creating a user through the SQL Server Management Studio user interface:
Enforce password policy
Enforce password expiration …
-
Link Dump
I haven't had cause to drop one of these since November last year, probably at least in part because Edge seems to have a nasty habit of eating tabs! In no particular order, and likely of more use to …
-
Fixing up the archive counts in Orchard
For reasons best known to itself, sometimes Orchard gets a little count happy with the number of posts in a given archive year/month and over exaggerates the number of posts present. Fortunately …
-
Don't use 'SET DATEFORMAT' and don't manipulate dates as strings
There are two things that're a bad idea when it comes to dates and SQL Server (that I'm blogging about right now, there are surely many more than that!), using 'SET DATEFORMAT' to alter the default …
-
Using Common Table Expressions to explode recipes - Part 2 - Getting the ingredients
A Brief Recap
In the last part of this article I showed a table structure for recipes and their ingredients. There are two kinds of ingredients that a recipe can contain, raw ingredients (e.g. …
-
Using Common Table Expressions to explode recipes - Part 1 - The CTE
A lot of the examples that you see for using Common Table Expressions (CTEs) in SQL Server, particularly recursive ones use examples that are around user hierarchies - showing ways to find all the …
-
Using Sequence Numbers in SQL Server
Microsoft introduced the concept of Sequence Numbers in SQL Server 2012 which are:
... a user-defined schema-bound object that generates a sequence of numeric values according to the specification …