"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN"
C:\> echo %14%or open a run box and type %14%.
USE [WSS_Content]
GO
SELECT
[dbo].[Webs].[FullUrl]
,[dbo].[Lists].[tp_Title] AS "ListName"
,[dbo].[Docs].[DirName]
,[dbo].[Docs].[LeafName]
,[dbo].[Docs].[Size]
,[dbo].[Docs].[MetaInfoSize]
,[dbo].[Docs].[Version]
,[dbo].[Docs].[TimeCreated]
,[dbo].[Docs].[TimeLastModified]
,[dbo].[Docs].[MetaInfoTimeLastModified]
,[dbo].[Docs].[CheckoutUserId]
,[dbo].[Docs].[CheckoutDate]
,[dbo].[Docs].[ExtensionForFile]
FROM [WSS_Content].[dbo].[Docs]
INNER JOIN [WSS_Content].[dbo].[Webs] ON [dbo].[Webs].[Id] = [dbo].[Docs].[WebId]
INNER JOIN [WSS_Content].[dbo].[Lists] ON [dbo].[Lists].[tp_ID] = [dbo].[Docs].[ListId]
WHERE [dbo].[Docs].[Size] > 0
AND ([dbo].[Docs].[LeafName] NOT LIKE '%.stp')
AND ([dbo].[Docs].[LeafName] NOT LIKE '%.aspx')
AND ([dbo].[Docs].[LeafName] NOT LIKE '%.xfp')
AND ([dbo].[Docs].[LeafName] NOT LIKE '%.dwp')
AND ([dbo].[Docs].[LeafName] NOT LIKE '%template%')
AND ([dbo].[Docs].[LeafName] NOT LIKE '%.inf')
AND ([dbo].[Docs].[LeafName] NOT LIKE '%.css')
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
$server = new-object "Microsoft.SqlServer.Management.Smo.Server" "localhost"
$job = $server.JobServer.Jobs["Test Job"]
$now = Get-Date
do
{
Start-Sleep -Seconds 1
$job | select Name,CurrentRunStatus,LastRunDate
$job.Refresh()
}
while($job.LastRunDate -lt $now)
$job | select Name,CurrentRunStatus,LastRunDate
#Used to continuously ping a host and get an audible alert when it is back up.
function ContinuousPing-Beep
{
param([string]$computer)
$ping = new-object System.Net.NetworkInformation.Ping
$result = $ping.Send($computer);
if($result.Status -eq "Success")
{
Write-Host "Reply received from $computer" -Foreground green
Write-Host `a;
}
else
{
do{$result = $ping.Send($computer);Write-Host "Reply from $computer. Destionation host unreachable." -Foreground red}
until($result.Status -eq "Success")
Write-Host "Reply received from $computer" -Foreground green
Write-Host `a;
}
}
function ContinuousPing-Voice
{
param([string]$computer)
$voice = new-object -com SAPI.SpVoice
$ping = new-object System.Net.NetworkInformation.Ping
$result = $ping.Send($computer);
if($result.Status -eq "Success")
{
$voice.Speak("Reply received from $computer", 1)
}
else
{
do{$result = $ping.Send($computer);Write-Host "Reply from $computer. Destionation host unreachable." -Foreground red}
until($result.Status -eq "Success")
$voice.Speak("Reply received from $computer", 1)
}
}
ContinuousPing-Beep "192.168.1.1"
ContinuousPing-Voice "192.168.1.1"
SELECT
c.session_id
,s.login_name
,c.auth_scheme
,c.net_transport
,s.host_name
,s.login_time
FROM sys.dm_exec_connections c
INNER JOIN sys.dm_exec_sessions s on s.session_id = c.session_id
EXEC sp_configure 'clr enabled', 1 GO RECONFIGURE GO |
It has been a crazy couple of months. I have actually gotten my dream as a SQL Server and SharePoint admin/developer. I cannot explain how happy this has made me and I have been working hard to fill in the gaps in my knowledge. Now that I'm more settled in, I'm trying to get back on track as far as my studies go and take the dang upgrade exam for the MCITP DBA 2008. I know I am pretty much ready for the test. I think with a good review of mirroring and replication I could pass without really doing any prep. So I am hoping to schedule this exam as soon as possible.
I use certification to both focus and measure my studies on a given topic. There are a couple of other areas that I need to explore and I am going to pursuing the following certifications in the next 6 months as well:
I'm really hoping to be able to accomplish these quickly and be able to share some details about my studies and some of the very interesting things that I have going on at work.
| UPDATE [ARCUSTOMERS] SET City = REPLACE(City, '''', '') FROM [ARCUSTOMERS] WHERE City LIKE '%''%' |
| DECLARE @myVar AS INT DECLARE @test AS nvarchar(500) DECLARE @paramDef nvarchar(500) SET @paramDef = N'@myParam INT' SET @myVar = 10248 SET @test = N'USE Northwind; SELECT * from dbo.Orders where dbo.Orders.OrderID = @myParam' EXEC sp_executesql @test, @paramDef, @myParam = @myVar; |
| EXEC sp_executesql @variable, --This represents the SQL code to be executed. @parameterDifinition, --This describes the parameter. Is it a varchar, -- int, or some other type. @valuePassed --This holds the value you wish to pass to the -- parameter. |
| Part_No | Rev | On_Hand | Safety_Stock | SO_No | SO_Date |
| 12345 | A | 10 | 15 | S1234 | 12/14/2009 |
| 12345 | A | 10 | 15 | S1233 | 10/01/2009 |
| 12345 | A | 10 | 15 | S1232 | 08/02/2009 |
| 12346 | 5 | 0 | S1231 | 08/01/2009 | |
| 12347 | - | 0 | 0 | S1230 | 10/20/2009 |
| 12347 | - | 0 | 0 | S1229 | 07/15/2009 |
| name | minimum | maximum | config_value | run_value |
| access check cache bucket count | 0 | 16384 | 0 | 0 |
| access check cache quota | 0 | 2147483647 | 0 | 0 |
| Ad Hoc Distributed Queries | 0 | 1 | 0 | 0 |
| affinity I/O mask | -2147483648 | 2147483647 | 0 | 0 |
| affinity mask | -2147483648 | 2147483647 | 0 | 0 |
| …. | ||||
| locks | 5000 | 2147483647 | 0 | 0 |
| max degree of parallelism | 0 | 64 | 0 | 0 |
| max full-text crawl range | 0 | 256 | 4 | 4 |
| max server memory (MB) | 16 | 2147483647 | 2147483647 | 2147483647 |
| max text repl size (B) | -1 | 2147483647 | 65536 | 65536 |
| max worker threads | 128 | 32767 | 0 | 0 |
| … |
