Posts
Sort by recent activity
Bug found in SQL Prompt
Here are the repro steps.
In a query window that has AdventureWorks2012 as the active DB (probably works in other AW versions too), paste the following code:
SELECT sod.SalesOrderID,
(SELECT ...
Single-quote handling changed??
Hi!
I noticed an oddity with SQLPrompt that I am pretty sure was not there before. This might be related to my upgrade to SSMS 17.3, as that is the only thing I recently changed.
Based on my prefer...
Errors on starting SSMS
Hi all!
Just now I got a bunch of errors when I was starting SSMS (by double-clicking on a .ssmssln file). Not at all sure if this is related to having the SQL Toolbelt installed or not, but some o...
New laptop
Hi all!
I have received my new laptop and am now slowly migrating my stuff. I have already installed the most important applications (SQL Server, versions 2012, 2014, and 2016; along with SSMS). An...
Issues with PIVOT
Hi!
Not sure if this is still relevant since I am quite behind in updates (runing SQL Prompt 7.1.0.144). But I figured I'd better report what I've seen and let you guys laught it off if this has al...
Computed columns
Hi all,
I'm trying to use SQL Data Generator (version 2.0.3.1) to generate extra data for the FactResellerSales table in the AdventureWorksDW2012 sample database. But in order to make it match the ...
Weigthed list generator - maximum weight
Hi all,
I'm trying to use SQL Data Generator (version 2.0.3.1) to generate extra data for the FactResellerSales table in the AdventureWorksDW2012 sample database. But in order to make it match the ...
Foreign Key Generator - request
Hi all,
I'm trying to use SQL Data Generator (version 2.0.3.1) to generate extra data for the FactResellerSales table in the AdventureWorksDW2012 sample database. But in order to make it match the ...
Datetime / Offset from column - request
Hi all,
I'm trying to use SQL Data Generator (version 2.0.3.1) to generate extra data for the FactResellerSales table in the AdventureWorksDW2012 sample database. But in order to make it match the ...
Wishes for synchronization
Hi all,
While using SQL Data Compare 6 (version 6.1.1.308), I found some issues with the code generated by the synchronziation wizard.
The scenario: I have some versioned data - so there is a "Vers...