You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.
2018-03-23 (first published: 2015-09-07)
6,429 reads
A new series to take you through the basics of how to get started using Azure as your own personal lab.
2015-11-03
2,999 reads
SQL Server Databases are made up of physical and logical names. This article goes over the logical names, where you might need to know them, and then how to change them.
2015-07-20
8,850 reads
SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.
2015-02-12
62,407 reads
You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.
2014-12-09
13,737 reads
You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.
2014-11-04
60,334 reads
Need to know how to verify if a login has server-level access to your SQL Server instance?
2014-06-17
2,837 reads
Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.
2013-02-22 (first published: 2011-01-24)
25,082 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers