I am totally pumped up about having the opportunity to present at SQL Saturday #268 in North Haven.
It will be a good time to meet old friends and make new ones. I hope you have time to attend cool event on March 1st, 2014!
Effective use of temporary tables
In the last article, we verified that Windows PowerShell was installed on my laptop and determined the version of the scripting engine. This tallk will be center around how to execute scripts from the command line.
For a simple test case, I created a C:\TEMP directory. Inside that directory is a script named “LIST-ROOT.PS1″ [...]
I have been recently devoting a-lot of time answering questions on STACKOVERFLOW.
Many times, you are just helping and/or teaching younger SQL Server developers and/or administrators the tricks of the trade. Sometimes you come across a GEM, a question that you can blog about so that when they are asked again, you [...]
There are many companies in the world that have offices in remote locations. Sometimes downloading software media from Microsoft or Oracle might take minutes if not hours. During this time, your terminal session with the remote computer might time out. How do you prevent this from happening?
The windows server operating system allows [...]
There are two main categories of logins in SQL Server. There are WINDOWS logins in which password restrictions are controlled by the Active Directory (AD) policy. Then there are SQL logins in which the database administrator has more control.
Lately, I have been crafting new database servers with the latest hardware to make [...]
I am really honored to have the opportunity to present at SQL Saturday #262 in Boston.
It will be a good time to meet old friends and make new ones. Since, the schedule has not officially been posted, I can not name the headliners that I looking forward to hear presentations from. [...]
I am looking forward to my first live presentation for the PASS Database Administration Virtual Chapter next week.
If you are interested in the topic, please register for the webinar on Wednesday, January 22, 2014 at Noon, Eastern Standard time. Registration is required and you will be automatically entered in [...]
PowerShell comes installed as part of the operating system in Windows 7. I checked my system which is a base install of Windows 7 SP1.
The ISE or integrated scripting envrionment is the place to code, debug and launch scripts.
To open the development environment, type powershell_ise at the run or command [...]
I just finished blog entry two hundred seventy in December 2013. It is quite an accomplishment since it takes one or two hours to research and design to compose an good article. I figured it was time to reset my goals for the upcoming year.
Here is what I am planning for [...]
I am delighted about the opportunity to present to the Stamford SQL Server User Group on December 16, 2013.
I have not had the pleasure in visiting UCONN’s campus in Stamford, CT. In fact, I have not been in that city since SQL Saturday New York last August. I am looking forward [...]
March 2014 M T W T F S S « Feb 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Cloud TagsALTER TABLE ALTER TRIGGER BEGIN CREATE DATABASE create function create procedure CREATE TABLE create trigger create view database administrator database developer DATEPART date time functions DDL DECLARE DELETE DROP TRIGGER DROP VIEW EXISTS FORMAT free code IF INSERT ISNULL John F. Miner III math function PASS perl script Presentation PRINT REPLACE SELECT sp_help sp_helptext SQL Server SQL Server Management Studio SSMS. string function sys.objects TRIGGERS TRUNCATE TABLE TSQL UPDATE vb script while