PS H:\> $cred = Get-StoredCredential -Target “VANLANDEGHEMB” #using PSModule “CredentialManager 2.0” PS H:\> # Create a remote session to the server PS H:\> enter-pssession -ComputerName MyServer -Credential $cred [MyServer]: PS C:\> query session SESSIONNAME USERNAME ID STATE TYPE DEVICE >services 0 Disc console 1 Conn rdp-tcp#27 VANLANDEGHEMB 60 Active rdp-tcp 65536 Listen [MyServer]: PS C:\> […]
Lots of blog posts talk about finding the IP address of the SQL Server instance. For most, this is about looking at sys.dm_exec_connections or selecting CONNECTIONPROPERTY(‘local_net_address’). The problem with those techniquest is that they only work from a remote connection via TCP/IP. Others talk about finding the IP address via xp_cmdshell and parsing the output of ‘ipconfig’. The same […]
A quick example on using the “&” (Bitwise AND) operator in SQL Server. This can be used to interpret status bits from an application. In this example I will use the status column from master..sysdatabases because it is easily available on SQL server so you don’t need to create any tables to test this example. […]
‘ Created by Bert Van Landeghem 16/01/2015 ‘ How to use: ‘ -i scriptfile ‘ -s https://SSRS_server_url/reportserver ‘ -v REPORT_PATH=”path to report for which to create a snapshot” ‘ ‘ Example command line: ‘ “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\rs.exe” -i C:\test\CreateReportSnapshot.rss -s http://reporting2012.localnet.be/ReportServer -v REPORT_PATH=”/Lists/CentralPrint” ‘ ‘ ReportingService2010 Methods (ReportService2010) ‘ [http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010_methods.aspx] Public Sub Main() […]
Fairly easy, extensible and readable way to get system information from SQL Server for reporting without having to create a complex system. The code in the Common Table Expressions (WITH…) are from the SQL Server DMV Diagnostics Queries by Glenn Berry. DROP VIEW server_config GO CREATE VIEW server_config (server_config) AS WITH os_windows_info as ( SELECT […]
During the implementation of Ola Hallengren’s SQL Server Maintenance Solution, we had a requirement to be able to set different parameters at different times to be able to fit the work in the available maintenance window. For example during the index maintenance part, we would set higher fragmentation thresholds during weekdays than during the weekend, […]
Nice way to automate part of the tuning effort: Exploring Query Plans in SQL https://www.simple-talk.com/sql/database-administration/exploring-query-plans-in-sql/?utm_source=simpletalk&utm_medium=email-main&utm_content=queryplans-20150105&utm_campaign=sql
MSMQ Errors in the Cluster.log http://blogs.msdn.com/b/clustering/archive/2013/04/05/10408075.aspx PS C:\> Remove-ClusterResourceType MSMQ PS C:\> Remove-ClusterResourceType MSMQTriggers
$items = “abt”,”about”,”after”,”again”,”air”,”all”,”along”,”also”,”an”,”and”,”another”,”in”,”year”,”you”,”your”,”was” #about_Regular_Expressions #http://technet.microsoft.com/en-us/library/hh847880.aspx #$pattern = [regex] “ab[\w]{1}$” #$pattern = “^[ai]n$”, “you*” $pattern = “^a.[rl]{1}”, “you*” Write-Host “— Option 1 —” $pattern | %{ $items -match $_ } Write-Host “—————-” Write-Host “— Option 2 —” $items | Select-String -Pattern $pattern | foreach-object{$_.tostring()} Write-Host “—————-” # Result: # — Option 1 — # air # […]
When SQL code doesn’t run on all versions, below is an elegant way for conditional execution. I needed this because I wanted to automate some of Glenn Berry’s DMV scripts, of which some only run on SQL 2008 R2 SP1 or higher. The DMV scripts can be found here: DMV Queries | Glenn Berry’s SQL […]
Bert's Blog 