Getting started with SQL 2019 big data cluster in Azure
Installing and connecting to SQL 2019 big data cluster
2020-06-26 (first published: 2019-01-17)
3,182 reads
Blesson John
Protect the Excel files generated by SSIS package-Part I
It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed
2010-10-28
12,118 reads
Changing Server Collation on SQL Server 2008
In this article, learn about the risks of changing server collation as well as how to go about making this change.
2010-09-20
15,205 reads
SQL Server 2008,Windows 2008 x64 and Excel
Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.
2010-07-28
7,288 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
NFC Wild Card Breakdown: Cowboys vs. Packers
The Fresh Orleans Saints are shed the playoffs for the 3rd instantly time, which...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers