Installing SQL Server 2014 CTP1 – Step by Step
Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your...
2013-06-25
2,973 reads
Blog Posts
NYC SQL User Group Mtg - Building a Personal Brand
This month, Thursday, June 27, 2013, the NYC SQL User Group be doing something a little different. Instead of a technical presentation,...
2013-06-25
938 reads
Share t-sql snippets to the team with SQL Prompt
Red-Gate SQL Prompt is a plugin for SQL Server Management Studio that makes the developers life easier when writing t-sql....
2013-06-25
1,879 reads
SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 1
Here are some scripts which can be used for setting up 2 nodes AlwaysOn Availability Groups, you can make your own...
2013-06-25
2,541 reads
SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 2
3. Install SQL Instance
a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer"...
2013-06-25
2,118 reads
SQL Server 2012 AlwaysOn Availability Groups setup scripts - Part 3
4. Setup 2 nodes alwayson availability group
a) Enable alwayson on both 2 nodes
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-01\DEFAULT"
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-02\DEFAULT"
b) Restore...
2013-06-25
2,258 reads
SQl Server 2014 CTP1
CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can...
2013-06-25
681 reads
SQL Server 2014 CTP1 is here!
As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server...
2013-06-25
1,217 reads
SQL Server 2014 CTP1 Released
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...
2013-06-25
596 reads
SQL Server: Part1 : All About SQL Server Statistics :Density Vector
In our daily life, we use the statistics to take the decision. In the same way SQL server optimizer use...
2013-06-25
11,025 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers