Category: Microsoft
Category Archives: Microsoft
To Do – Due Date Selector Not Working
I noticed that when you go to select a due date in To Do from the calendar or even select an option like “tomorrow” instead of displaying the correct date it always shows the date of the day before.
For example, I select 5/20/24 and it displays 5/19/24.
I’ve attached a link to a video showing the issue.
https://drive.google.com/file/d/13_hj9hNBm_PG0p4UMvFoyvlE0AVInROs/view?usp=sharing
I noticed that when you go to select a due date in To Do from the calendar or even select an option like “tomorrow” instead of displaying the correct date it always shows the date of the day before. For example, I select 5/20/24 and it displays 5/19/24. I’ve attached a link to a video showing the issue.https://drive.google.com/file/d/13_hj9hNBm_PG0p4UMvFoyvlE0AVInROs/view?usp=sharing Read More
Service Broker Readers
Hi,
I am using service broker as a means to process events.
I have an activation procedure, that reads a single message, processes that message and then finishes.
My queue has 10 readers.
In the activation procedure I log the SPID and the login time of the session and my expectation would be, that each messages has a unique combination of SPID and login time of the session.
That is true most of the time.
Sometimes however, a sessions seems to be re-used, meaning that more that one message (as per now always three) are processed by the same session (combination of SPID and login time).
Does the service broker recycle readers and if yes, is that something that can be configured/controlled?
Thanks a lot in advance
Chris
Hi,I am using service broker as a means to process events.I have an activation procedure, that reads a single message, processes that message and then finishes.My queue has 10 readers.In the activation procedure I log the SPID and the login time of the session and my expectation would be, that each messages has a unique combination of SPID and login time of the session. That is true most of the time. Sometimes however, a sessions seems to be re-used, meaning that more that one message (as per now always three) are processed by the same session (combination of SPID and login time). Does the service broker recycle readers and if yes, is that something that can be configured/controlled? Thanks a lot in advanceChris Read More
Intune Suite features
Still no online status for devices? Or ability to send keystrokes for secure password input for UAC prompts when on a remote session? Or unattended access for windows devices that are not logged in? Seriously Microsoft…. lots of catching up to do…. please take a look at N-able’s remote support products to get a sense of how far behind this still is. I imagine there is a way to see the device runtime (at least for Windows) but not sure how to do this if there is so if anyone could let me know that would be much appreciated
Still no online status for devices? Or ability to send keystrokes for secure password input for UAC prompts when on a remote session? Or unattended access for windows devices that are not logged in? Seriously Microsoft…. lots of catching up to do…. please take a look at N-able’s remote support products to get a sense of how far behind this still is. I imagine there is a way to see the device runtime (at least for Windows) but not sure how to do this if there is so if anyone could let me know that would be much appreciated Read More
Bookings to Excel via Automate
I have a Booking Page that creates a new row in excel spreadsheet when a new booking is made. I have each column in my table mapped.
What I need is the date & time in separate columns in my table. In Power Automate, it only has options to map startdate and enddate each “jumbles” the appointment start date & time in one column.
Is there a function or expression to make this work?
I have a Booking Page that creates a new row in excel spreadsheet when a new booking is made. I have each column in my table mapped.What I need is the date & time in separate columns in my table. In Power Automate, it only has options to map startdate and enddate each “jumbles” the appointment start date & time in one column.Is there a function or expression to make this work? Read More
Copilot suggestions
Looking for best way to source a research asset library that contains files on different topics. Want to ask demographic or product specific questions and have copilot pull answers.
The asset library sits within our company intranet sharepoint site so it’s more than 2 levels deep.
Also, I have tried to apply a copilot to a client site containing a document library and copilot is not pulling any information on things I know it should be able to find.
Any suggestions would be appreciated.
Thanks!
Looking for best way to source a research asset library that contains files on different topics. Want to ask demographic or product specific questions and have copilot pull answers. The asset library sits within our company intranet sharepoint site so it’s more than 2 levels deep. Also, I have tried to apply a copilot to a client site containing a document library and copilot is not pulling any information on things I know it should be able to find. Any suggestions would be appreciated.Thanks! Read More
Targeted release
Hello
Is there a way to pull out a list of users that have targeted release?
I am looking for a powershell script.
Regards
JFM_12
HelloIs there a way to pull out a list of users that have targeted release?I am looking for a powershell script.RegardsJFM_12 Read More
Make report with all devices, username and last restart date
Hello,
How to make report from Intune/Ms graph for all devices with last resatart date (time)?
Thanks
Hello, How to make report from Intune/Ms graph for all devices with last resatart date (time)? Thanks Read More
Will VBA be obsolete from excel?
We have been receiving news about macros that it will be obsolete soon? Not sure if we should believe it or not? We have a product largely based on macros. if its true, we need to find option.
We have been receiving news about macros that it will be obsolete soon? Not sure if we should believe it or not? We have a product largely based on macros. if its true, we need to find option. Read More
Formula to get address of selected cell on a worksheet
Hi,
I’m looking for a formula to get the currently selected cell within a worksheet.
No VBA or macros since my client has that disabled.Not the last cell edited since an edit may not occur.It can’t be affected by changes of selection on other worksheets.
This is obviously information that Excel tracks and there is no good reason why it wouldn’t be readily available. (I know there is always the possibility of bad reasons they may keep this information inaccessible, but I’m hoping that isn’t the case.)
Any help would be appreciated.
Thank you,
John
Hi, I’m looking for a formula to get the currently selected cell within a worksheet.No VBA or macros since my client has that disabled.Not the last cell edited since an edit may not occur.It can’t be affected by changes of selection on other worksheets.This is obviously information that Excel tracks and there is no good reason why it wouldn’t be readily available. (I know there is always the possibility of bad reasons they may keep this information inaccessible, but I’m hoping that isn’t the case.)Any help would be appreciated. Thank you, John Read More
Lesson Learned #484: Database Performance Monitoring with PowerShell and ReadScale-Out Environments
Today, I handled a service request from our customer seeking additional information on performance monitoring for ReadScale-Out in Azure SQL Database. They needed details on how to find missing indexes, query statistics, and more.
I created this PowerShell script that works for both Elastic Database Pools and standalone databases, executing multiple queries for monitorin
The following PowerShell script connects to a read-only replica, retrieves performance data, and stores it for future analysis. This article will guide you through the steps required to implement this script in your own environment and could be possible to use for Single Azure SQL Database, Azure SQL Elastic Pool or Azure SQL Managed Instance.
Check if the statistics
If number of rows in the statistics is different of rows_sampled.
If we have more than 15 days that the statistics have been updated.
Check if the statistics associated to any index is:
If number of rows in the statistics is different of rows_sampled.
If we have more than 15 days that the statistics have been updated.
Check if MAXDOP is 0
Check if we have missing indexes
Obtain resource usage per database.
Total amount of space and rows per schema and table name
Query stats summary.
Basically we need to configure the parameters:
$server = “xxxxx.database.windows.net” // Azure SQL Server name
$user = “xxxxxx” // User Name
$passwordSecure = “xxxxxx” // Password
$Db = “xxxxxx” // Database Name, if you type the value ALL, all databases will be checked.
$Folder = $true // Folder where the log file will be generated with all the issues found.
DropExisting =value 1 or 0, if the previous files located on Destinatio folder will be deleted every time that you execute the process.
ElasticDBPoolName. PowerShell Script will check all the databases that are associated with this elastic database pool (only for Azure SQL Database).
Create a subfolder with date and time used in every execution
PerfChecker.Log = Contains all the issues found.
Every check done will save two files
Extension .Txt that contains the report of the operation done.
Extension .task that contains a possible mitigation about the issue found.
Script
#—————————————————————-
# Application: ReadScale-Out Performance Checker
# Propose: Inform about performance recomendations for ReadScale-Out
# Checks:
# 1) Check if the statistics
# If number of rows in the statistics is different of rows_sampled.
# If we have more than 15 days that the statistics have been updated.
# 2) Check if we have any auto-tuning recomendations
# 3) Check if the statistics associated to any index is:
# If number of rows in the statistics is different of rows_sampled.
# If we have more than 15 days that the statistics have been updated.
# 4) Check if MAXDOP is 0
# 5) Check if we have missing indexes (SQL Server Instance)
# 6) Obtain resource usage per database.
# 7) Total amount of space and rows per table.
# 8) Query Stats summary
# Outcomes:
# In the folder specified in $Folder variable we are going to have a file called PerfChecker.Log that contains all the operations done
# and issues found. Also, we are going to have a file per database and check done with the results gathered.
# Every time that the process is executed it is created a new subfolder.
#—————————————————————-
#—————————————————————-
#Parameters
#—————————————————————-
param($server = “myserver.database.windows.net”, #ServerName parameter to connect,for example, myserver.database.windows.net
$user = “username”, #UserName parameter to connect
$passwordSecure = “pwd!”, #Password Parameter to connect
$Db = “DBName”, #DBName Parameter to connect. Type ALL to check all the databases running in the server
$Folder = “c:SQLDAta”, #Folder Parameter to save the log and solution files, for example, c:PerfChecker
$DropExisting=1, #Drop (1) the previous file saved in the folder with extensions .csv, .txt, .task !=1 = leave the files
$ElasticDBPoolName = “dbPoolName”) #Name of the elastic DB Pool if you want to filter only by elastic DB Pool.
#——————————————————————————-
# Check the statistics status
# 1.- Review if number of rows is different of rows_sampled
# 2.- Review if we have more than 15 days that the statistics have been updated.
#——————————————————————————-
function CheckStatistics($connection,$FileName, $FileNameLogSolution , $iTimeOut)
{
try
{
$Item=0
logMsg( “—- Checking Statistics health (Started) (REF: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver15)—- ” ) (1) $true $FileName
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand
$command.CommandTimeout = $iTimeOut
$command.Connection=$connection
$command.CommandText = “SELECT sp.stats_id, stat.name, o.name, filter_definition, last_updated, rows, rows_sampled, steps, unfiltered_rows, modification_counter, DATEDIFF(DAY, last_updated , getdate()) AS Diff, schema_name(o.schema_id) as SchemaName
FROM sys.stats AS stat
Inner join sys.objects o on stat.object_id=o.object_id
CROSS APPLY sys.dm_db_stats_properties(stat.object_id, stat.stats_id) AS sp
WHERE o.type = ‘U’ AND stat.auto_created =’1′ or stat.user_created=’1′ order by o.name, stat.name”
$Reader = $command.ExecuteReader();
while($Reader.Read())
{
if( $Reader.GetValue(5) -gt $Reader.GetValue(6)) #If number rows is different rows_sampled
{
$Item=$Item+1
logMsg(“Possible outdated (Rows_Sampled is less than rows of the table):”.PadRight(100,” “) + ” of ” + ($Reader.GetValue(11).ToString() +”.”+ ($Reader.GetValue(2).ToString() + ” ” + $Reader.GetValue(1).ToString())).PadRight(400,” “)) (2) $true $FileName
logSolution(“UPDATE STATISTICS [” + $Reader.GetValue(11).ToString() +”].[“+ $Reader.GetValue(2).ToString() + “]([” + $Reader.GetValue(1).ToString() + “]) WITH FULLSCAN”) $FileNameLogSolution
}
if( TestEmpty($Reader.GetValue(10))) {}
else
{
if($Reader.GetValue(10) -gt 15) #if we have more than 15 days since the lastest update.
{
$Item=$Item+1
logMsg(“Possible outdated (15 days since the latest update):”.PadRight(100,” “) + ” of ” + ($Reader.GetValue(11).ToString() +”.”+ ($Reader.GetValue(2).ToString() + ” ” + $Reader.GetValue(1).ToString())).PadRight(400,” “)) (2) $true $FileName
logSolution(“UPDATE STATISTICS [” + $Reader.GetValue(11).ToString() +”].[“+ $Reader.GetValue(2).ToString() + “]([” + $Reader.GetValue(1).ToString() + “]) WITH FULLSCAN”) $FileNameLogSolution
}
}
}
$Reader.Close();
logMsg( “—- Checking Statistics health (Finished) —- ” ) (1) $true -$FileName
return $Item
}
catch
{
logMsg(“Not able to run statistics health checker…” + $Error[0].Exception) (2) $true $FileName
return 0
}
}
#——————————————————————————-
# Check missing indexes.
#——————————————————————————-
function CheckMissingIndexes($connection ,$FileName, $FileNameLogSolution , $iTimeOut)
{
try
{
$Item=0
logMsg( “—- Checking Missing Indexes (Started) Ref: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-missing-index-groups-transact-sql?view=sql-server-ver15 —- ” ) (1) $true $FileName
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand
$command.CommandTimeout = $iTimeOut
$command.Connection=$connection
$command.CommandText = “SELECT CONVERT (varchar, getdate(), 126) AS runtime,
CONVERT (decimal (28,1), migs.avg_total_user_cost * migs.avg_user_impact *
(migs.user_seeks + migs.user_scans)) AS improvement_measure,
REPLACE(REPLACE(‘CREATE INDEX missing_index_’ + CONVERT (varchar, mig.index_group_handle) + ‘_’ +
CONVERT (varchar, mid.index_handle) + ‘ ON ‘ + LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(mid.statement,CHAR(10), ‘ ‘), CHAR(13), ‘ ‘),’ ‘,”))) +
‘(‘ + ISNULL (mid.equality_columns,”)
+ CASE WHEN mid.equality_columns IS NOT NULL
AND mid.inequality_columns IS NOT NULL
THEN ‘,’ ELSE ” END + ISNULL (mid.inequality_columns, ”)
+ ‘)’
+ ISNULL (‘ INCLUDE (‘ + mid.included_columns + ‘)’, ”), CHAR(10), ‘ ‘), CHAR(13), ‘ ‘) AS create_index_statement,
migs.avg_user_impact
FROM sys.dm_db_missing_index_groups AS mig
INNER JOIN sys.dm_db_missing_index_group_stats AS migs
ON migs.group_handle = mig.index_group_handle
INNER JOIN sys.dm_db_missing_index_details AS mid
ON mig.index_handle = mid.index_handle
ORDER BY migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks + migs.user_scans) DESC”
$Reader = $command.ExecuteReader()
$bFound=$false
$bCol=$false
$ColName=””
$Content = [System.Collections.ArrayList]@()
while($Reader.Read())
{
#Obtain the columns only
if($bCol -eq $false)
{
for ($iColumn=0; $iColumn -lt $Reader.FieldCount; $iColumn++)
{
$bCol=$true
$ColName=$ColName + $Reader.GetName($iColumn).ToString().Replace(“t”,” “).Replace(“n”,” “).Replace(“r”,” “).Replace(“rn”,””).Trim() + ” || “
}
}
#Obtain the values of every missing indexes
$bFound=$true
$TmpContent=””
for ($iColumn=0; $iColumn -lt $Reader.FieldCount; $iColumn++)
{
$TmpContent= $TmpContent + $Reader.GetValue($iColumn).ToString().Replace(“t”,” “).Replace(“n”,” “).Replace(“r”,” “).Replace(“rn”,””).Trim() + ” || “
}
$Content.Add($TmpContent) | Out-null
}
if($bFound)
{
logMsg( “—- Missing Indexes found —- ” ) (1) $true $FileName
logMsg( $ColName.Replace(“t”,””).Replace(“n”,””).Replace(“r”,””) ) (1) $true $FileName $false
for ($iColumn=0; $iColumn -lt $Content.Count; $iColumn++)
{
logMsg( $Content[$iColumn].Replace(“t”,””).Replace(“n”,””).Replace(“r”,””).Replace(“rn”,””).Trim() ) (1) $true $FileName $false
$Item=$Item+1
}
}
$Reader.Close();
logMsg( “—- Checking missing indexes (Finished) —- ” ) (1) $true $FileName
return $Item
}
catch
{
logMsg(“Not able to run missing indexes…” + $Error[0].Exception) (2) $true $FileName
return 0
}
}
#——————————————————————————-
# Check if the statistics associated to any index is:
# 1.- Review if number of rows is different of rows_sampled
# 2.- Review if we have more than 15 days that the statistics have been updated.
#——————————————————————————-
function CheckIndexesAndStatistics($connection, $FileName, $FileNameLogSolution , $iTimeOut )
{
try
{
$Item=0
logMsg( “—- Checking Indexes and Statistics health (Started) – Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver15 -” ) (1) $true $FileName
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand
$command.CommandTimeout = $iTimeOut
$command.Connection=$connection
$command.CommandText = “SELECT ind.index_id, ind.name, o.name, stat.filter_definition, sp.last_updated, sp.rows, sp.rows_sampled, sp.steps, sp.unfiltered_rows, sp.modification_counter, DATEDIFF(DAY, last_updated , getdate()) AS Diff, schema_name(o.schema_id) as SchemaName,*
from sys.indexes ind
Inner join sys.objects o on ind.object_id=o.object_id
inner join sys.stats stat on stat.object_id=o.object_id and stat.stats_id = ind.index_id
CROSS APPLY sys.dm_db_stats_properties(stat.object_id, stat.stats_id) AS sp
WHERE o.type = ‘U’ order by o.name, stat.name”
$Reader = $command.ExecuteReader();
while($Reader.Read())
{
if( $Reader.GetValue(5) -gt $Reader.GetValue(6)) #If number rows is different rows_sampled
{
$Item=$Item+1
logMsg(“Possible outdated – (Rows_Sampled is less than rows of the table):”.PadRight(100,” “) + ” of ” + ($Reader.GetValue(11).ToString() +”.”+ $Reader.GetValue(2).ToString() + ” ” + $Reader.GetValue(1).ToString()).PadRight(400,” “)) (2) $true $FileName
logSolution(“ALTER INDEX [” + $Reader.GetValue(1).ToString() + “] ON [” + $Reader.GetValue(11).ToString() +”].[“+ $Reader.GetValue(2).ToString() + “] REBUILD”) $FileNameLogSolution
}
if( TestEmpty($Reader.GetValue(10))) {}
else
{
if($Reader.GetValue(10) -gt 15)
{
$Item=$Item+1
logMsg(“Possible outdated – (15 days since the latest update):”.PadRight(100,” “) + ” of ” + ($Reader.GetValue(11).ToString() +”.”+ $Reader.GetValue(2).ToString() + ” ” + $Reader.GetValue(1).ToString()).PadRight(400,” “)) (2) $true $FileName
logSolution(“ALTER INDEX [” + $Reader.GetValue(1).ToString() + “] ON [” + $Reader.GetValue(11).ToString() +”].[“+ $Reader.GetValue(2).ToString() + “] REBUILD”) $FileNameLogSolution
}
}
}
$Reader.Close();
logMsg( “—- Checking Indexes and Statistics health (Finished) —- ” ) (1) $true $FileName
return $Item
}
catch
{
logMsg(“Not able to run Indexes and statistics health checker…” + $Error[0].Exception) (2) $true $FileName
return 0
}
}
#——————————————————————————-
# Check if MAXDOP is 0
#——————————————————————————-
function CheckScopeConfiguration($connection ,$FileName, $FileNameLogSolution , $iTimeOut)
{
try
{
$Item=0
logMsg( “—- Checking Scoped Configurations —- Ref: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-database-scoped-configurations-transact-sql?view=sql-server-ver15” ) (1) $true $FileName
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand
$command.CommandTimeout = $iTimeOut
$command.Connection=$connection
$command.CommandText = “select * from sys.database_scoped_configurations”
$Reader = $command.ExecuteReader();
while($Reader.Read())
{
if( $Reader.GetValue(1) -eq “MAXDOP”)
{
if( $Reader.GetValue(2) -eq 0)
{
logMsg(“You have MAXDOP with value 0” ) (2) $true $FileName
$Item=$Item+1
}
}
}
$Reader.Close();
logMsg( “—- Checking Scoped Configurations (Finished) —- ” ) (1) $true $FileName
return $Item
}
catch
{
logMsg(“Not able to run Scoped Configurations…” + $Error[0].Exception) (2) $true $FileName
return 0
}
}
#—————————————————————-
#Function to connect to the database using a retry-logic
#—————————————————————-
Function GiveMeConnectionSource($DBs)
{
for ($i=1; $i -lt 10; $i++)
{
try
{
logMsg( “Connecting to the database…” + $DBs + “. Attempt #” + $i) (1)
$SQLConnection = New-Object System.Data.SqlClient.SqlConnection
$SQLConnection.ConnectionString = “Server=”+$server+”;Database=”+$Dbs+”;User ID=”+$user+”;Password=”+$password+”;Connection Timeout=60;Application Name=ReadScaleOut Collector;ApplicationIntent=ReadOnly”
$SQLConnection.Open()
logMsg(“Connected to the database..” + $DBs) (1)
return $SQLConnection
break;
}
catch
{
logMsg(“Not able to connect – ” + $DBs + ” – Retrying the connection…” + $Error[0].Exception) (2)
Start-Sleep -s 5
}
}
}
#————————————————————–
#Create a folder
#————————————————————–
Function CreateFolder
{
Param( [Parameter(Mandatory)]$Folder )
try
{
$FileExists = Test-Path $Folder
if($FileExists -eq $False)
{
$result = New-Item $Folder -type directory
if($result -eq $null)
{
logMsg(“Imposible to create the folder ” + $Folder) (2)
return $false
}
}
return $true
}
catch
{
return $false
}
}
#——————————-
#Create a folder
#——————————-
Function DeleteFile{
Param( [Parameter(Mandatory)]$FileName )
try
{
$FileExists = Test-Path $FileNAme
if($FileExists -eq $True)
{
Remove-Item -Path $FileName -Force
}
return $true
}
catch
{
return $false
}
}
#——————————–
#Log the operations
#——————————–
function logMsg
{
Param
(
[Parameter(Mandatory=$true, Position=0)]
[string] $msg,
[Parameter(Mandatory=$false, Position=1)]
[int] $Color,
[Parameter(Mandatory=$false, Position=2)]
[boolean] $Show=$true,
[Parameter(Mandatory=$false, Position=3)]
[string] $sFileName,
[Parameter(Mandatory=$false, Position=4)]
[boolean] $bShowDate=$true
)
try
{
if($bShowDate -eq $true)
{
$Fecha = Get-Date -format “yyyy-MM-dd HH:mm:ss”
$msg = $Fecha + ” ” + $msg
}
If( TestEmpty($SFileName) )
{
Write-Output $msg | Out-File -FilePath $LogFile -Append
}
else
{
Write-Output $msg | Out-File -FilePath $sFileName -Append
}
$Colores=”White”
$BackGround =
If($Color -eq 1 )
{
$Colores =”Cyan”
}
If($Color -eq 3 )
{
$Colores =”Yellow”
}
if($Color -eq 2 -And $Show -eq $true)
{
Write-Host -ForegroundColor White -BackgroundColor Red $msg
}
else
{
if($Show -eq $true)
{
Write-Host -ForegroundColor $Colores $msg
}
}
}
catch
{
Write-Host $msg
}
}
#——————————–
#Log the solution
#——————————–
function logSolution
{
Param
(
[Parameter(Mandatory=$true, Position=0)]
[string] $msg,
[Parameter(Mandatory=$false, Position=3)]
[string] $sFileName
)
try
{
Write-Output $msg | Out-File -FilePath $sFileName -Append
}
catch
{
Write-Host $msg
}
}
#——————————–
#The Folder Include “” or not???
#——————————–
function GiveMeFolderName([Parameter(Mandatory)]$FolderSalida)
{
try
{
$Pos = $FolderSalida.Substring($FolderSalida.Length-1,1)
If( $Pos -ne “” )
{return $FolderSalida + “”}
else
{return $FolderSalida}
}
catch
{
return $FolderSalida
}
}
#——————————–
#Validate Param
#——————————–
function TestEmpty($s)
{
if ([string]::IsNullOrWhitespace($s))
{
return $true;
}
else
{
return $false;
}
}
#——————————–
#Separator
#——————————–
function GiveMeSeparator
{
Param([Parameter(Mandatory=$true)]
[System.String]$Text,
[Parameter(Mandatory=$true)]
[System.String]$Separator)
try
{
[hashtable]$return=@{}
$Pos = $Text.IndexOf($Separator)
$return.Text= $Text.substring(0, $Pos)
$return.Remaining = $Text.substring( $Pos+1 )
return $Return
}
catch
{
$return.Text= $Text
$return.Remaining = “”
return $Return
}
}
Function Remove-InvalidFileNameChars {
param([Parameter(Mandatory=$true,
Position=0,
ValueFromPipeline=$true,
ValueFromPipelineByPropertyName=$true)]
[String]$Name
)
return [RegEx]::Replace($Name, “[{0}]” -f ([RegEx]::Escape([String][System.IO.Path]::GetInvalidFileNameChars())), ”)}
function Replace-SpacesInRange {
param (
[string]$InputString)
# Replace matched spaces with a single space
$OutputString = ($InputString -replace “s+”,” “)
return $OutputString
}
#——————————————————————————-
# Check the rows, space used, allocated and numbers of tables.
#——————————————————————————-
function CheckStatusPerTable($connection ,$FileName, $iTimeOut)
{
try
{
logMsg( “—- Checking Status per Table —- ” ) (1) $true $FileName
$Item=0
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand
$command.CommandTimeout = $iTimeOut
$command.Connection=$connection
$command.CommandText = “SELECT s.Name + ‘.’ + t.name,
SUM(p.rows) AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
(SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
sys.schemas s ON t.schema_id = s.schema_id
WHERE t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
s.Name + ‘.’ + t.name”
$Reader = $command.ExecuteReader();
$StringReport = “Table “
$StringReport = $StringReport + “Rows “
$StringReport = $StringReport + “Space “
$StringReport = $StringReport + “Used “
logMsg($StringReport) (1) $false $FileName -bShowDate $false
while($Reader.Read())
{
$Item=$Item+1
$lTotalRows = $Reader.GetValue(1)
$lTotalSpace = $Reader.GetValue(2)
$lTotalUsed = $Reader.GetValue(3)
$lTotalUnUsed = $Reader.GetValue(4)
$StringReport = $Reader.GetValue(0).ToString().PadRight(100).Substring(0,99) + ” “
$StringReport = $StringReport + $lTotalRows.ToString(‘N0’).PadLeft(20) + ” “
$StringReport = $StringReport + $lTotalSpace.ToString(‘N0’).PadLeft(20) + ” “
$StringReport = $StringReport + $lTotalUsed.ToString(‘N0’).PadLeft(20)
logMsg($StringReport) (1) $false $FileName -bShowDate $false
}
$Reader.Close();
return $Item
}
catch
{
$Reader.Close();
logMsg(“Not able to run Checking Status per Table…” + $Error[0].Exception) (2)
return 0
}
}
#—————————————————————————————-
# Check query stats and obtain execution count, cpu_time, logical_reads, etc.. per query
#—————————————————————————————
function CheckQueryStats($connection ,$FileName, $iTimeOut)
{
try
{
logMsg( “—- Checking Query Stats —- ” ) (1) $true $FileName
$Item=0
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand
$command.CommandTimeout = $iTimeOut
$command.Connection=$connection
$command.CommandText = “SELECT
qs.execution_count,
qs.total_worker_time AS cpu_time,
qs.total_logical_reads AS avg_logical_reads,
qs.total_logical_writes AS avg_logical_writes,
qs.total_physical_reads AS avg_physical_reads,
qs.total_elapsed_time AS avg_elapsed_time,
st.text AS query_text
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st”
$Reader = $command.ExecuteReader();
$StringReport = “Execution Count “
$StringReport = $StringReport + “CPU Time “
$StringReport = $StringReport + “Logical Reads “
$StringReport = $StringReport + “Logical Writes “
$StringReport = $StringReport + “Physical Writes “
$StringReport = $StringReport + “Elapsed Time “
$StringReport = $StringReport + “TSQL “
logMsg($StringReport) (1) $false $FileName -bShowDate $false
while($Reader.Read())
{
$Item=$Item+1
$TSQL = $Reader.GetValue(6).ToString().Trim()
$cleanedString = Replace-SpacesInRange -InputString $TSQL
$StringReport = $Reader.GetValue(0).ToString(‘N0’).ToString().PadLeft(20) + ” “
$StringReport = $StringReport + $Reader.GetValue(1).ToString(‘N0’).PadLeft(20) + ” “
$StringReport = $StringReport + $Reader.GetValue(2).ToString(‘N0’).PadLeft(20) + ” “
$StringReport = $StringReport + $Reader.GetValue(3).ToString(‘N0’).PadLeft(20) + ” “
$StringReport = $StringReport + $Reader.GetValue(4).ToString(‘N0’).PadLeft(20) + ” “
$StringReport = $StringReport + $Reader.GetValue(5).ToString(‘N0’).PadLeft(20) + ” “
$StringReport = $StringReport + $cleanedString
logMsg($StringReport) (1) $false $FileName -bShowDate $false
}
$Reader.Close();
return $Item
}
catch
{
$Reader.Close();
logMsg(“Not able to run Checking Query Stats..” + $Error[0].Exception) (2)
return 0
}
}
#——————————————————————————-
# Show the performance counters of the database
#——————————————————————————-
function CheckStatusPerResource($connection,$FileName, $iTimeOut)
{
try
{
logMsg( “—- Checking Status per Resources —- ” ) (1) $true $FileName
$Item=0
$command = New-Object -TypeName System.Data.SqlClient.SqlCommand
$command.CommandTimeout = $iTimeOut
$command.Connection=$connection
$command.CommandText = “select end_time, avg_cpu_percent, avg_data_io_percent, avg_log_write_percent, avg_memory_usage_percent, max_worker_percent from sys.dm_db_resource_stats order by end_time desc”
$Reader = $command.ExecuteReader();
$StringReport = “Time “
$StringReport = $StringReport + “Avg_Cpu “
$StringReport = $StringReport + “Avg_DataIO “
$StringReport = $StringReport + “Avg_Log “
$StringReport = $StringReport + “Avg_Memory “
$StringReport = $StringReport + “Max_Workers”
logMsg($StringReport) (1) $false $FileName -bShowDate $false
while($Reader.Read())
{
$Item=$Item+1
$lTotalCPU = $Reader.GetValue(1)
$lTotalDataIO = $Reader.GetValue(2)
$lTotalLog = $Reader.GetValue(3)
$lTotalMemory = $Reader.GetValue(4)
$lTotalWorkers = $Reader.GetValue(5)
$StringReport = $Reader.GetValue(0).ToString().PadLeft(20) + ” “
$StringReport = $StringReport + $lTotalCPU.ToString(‘N2’).PadLeft(10) + ” “
$StringReport = $StringReport + $lTotalDataIO.ToString(‘N2’).PadLeft(10)
$StringReport = $StringReport + $lTotalLog.ToString(‘N2’).PadLeft(10)
$StringReport = $StringReport + $lTotalMemory.ToString(‘N2’).PadLeft(10)
$StringReport = $StringReport + $lTotalWorkers.ToString(‘N2’).PadLeft(10)
logMsg($StringReport) (1) $false $FileName -bShowDate $false
}
$Reader.Close();
return $Item
}
catch
{
logMsg(“Not able to run Checking Status per Resources…” + $Error[0].Exception) (2) $true $FileName
return 0
}
}
function sGiveMeFileName{
Param([Parameter(Mandatory=$true)]
[System.String]$DBAccess,
[Parameter(Mandatory=$true)]
[System.String]$File)
try
{
return $FolderV + $DBAccess + $File
}
catch {
return “_UnKnow.csv”
}
}
try
{
Clear
#——————————–
#Check the parameters.
#——————————–
if (TestEmpty($server)) { $server = read-host -Prompt “Please enter a Server Name” }
if (TestEmpty($user)) { $user = read-host -Prompt “Please enter a User Name” }
if (TestEmpty($passwordSecure))
{
$passwordSecure = read-host -Prompt “Please enter a password” -assecurestring
$password = [Runtime.InteropServices.Marshal]::PtrToStringAuto([Runtime.InteropServices.Marshal]::SecureStringToBSTR($passwordSecure))
}
else
{$password = $passwordSecure}
if (TestEmpty($Db)) { $Db = read-host -Prompt “Please enter a Database Name, type ALL to check all databases” }
if (TestEmpty($Folder)) { $Folder = read-host -Prompt “Please enter a Destination Folder (Don’t include the last ) – Example c:PerfChecker” }
$DbsArray = [System.Collections.ArrayList]::new()
#——————————–
#Variables
#——————————–
$CheckStatistics=0
$CheckIndexesAndStatistics=0
$CheckMissingIndexes=0
$CheckScopeConfiguration=0
$CheckStatusPerResource=0
$CheckStatusPerTable=0
$CheckQueryStats=0
$TotalCheckStatistics=0
$TotalCheckIndexesAndStatistics=0
$TotalCheckMissingIndexes=0
$TotalCheckScopeConfiguration=0
$TotalCheckStatusPerResource=0
$TotalCheckStatusPerTable=0
$TotalCheckQueryStats=0
#——————————–
#Run the process
#——————————–
$timestamp = Get-Date -Format “yyyyMMddHHmmss”
$Folder = $Folder +”” + $timestamp + “”
logMsg(“Creating the folder ” + $Folder) (1)
$result = CreateFolder($Folder) #Creating the folder that we are going to have the results, log and zip.
If( $result -eq $false)
{
logMsg(“Was not possible to create the folder”) (2)
exit;
}
logMsg(“Created the folder ” + $Folder) (1)
$sFolderV = GiveMeFolderName($Folder) #Creating a correct folder adding at the end .
$LogFile = $sFolderV + “PerfChecker.Log” #Logging the operations.
logMsg(“Deleting Operation Log file”) (1)
$result = DeleteFile($LogFile) #Delete Log file
logMsg(“Deleted Operation Log file”) (1)
logMsg(“——————– Header Filter details ————–“) (1)
logMsg(” ServerName: ” + $server) (1)
logMsg(” DB Filter : ” + $DB) (1)
logMsg(” Folder : ” + $Folder) (1)
logMsg(” Delete Files: ” + $DropExisting) (1)
logMsg(” Elastic DB Pool Name: ” + $ElasticDBPoolName) (1)
logMsg(“——————– Footer Filter details ————–“) (1)
if( $DropExisting -eq 1)
{
foreach ($f in ((Get-ChildItem -Path $sFolderV)))
{
if($f.Extension -in (“.txt”) -or $f.Extension -in (“.task”) )
{
logMsg(“Deleting Operation file: ” + $f.FullName) (1)
$result = DeleteFile($f.FullName)
logMsg(“Deleted Operation file: ” + $f.FullName) (1)
}
}
}
if($Db -eq “ALL”)
{
$SQLConnectionSource = GiveMeConnectionSource “master” #Connecting to the database.
if($SQLConnectionSource -eq $null)
{
logMsg(“It is not possible to connect to the database”) (2)
exit;
}
$commandDB = New-Object -TypeName System.Data.SqlClient.SqlCommand
$commandDB.CommandTimeout = 6000
$commandDB.Connection=$SQLConnectionSource
if(TestEmpty($ElasticDBPoolName))
{
$commandDB.CommandText = “SELECT name from sys.databases where database_id >=5 order by name”
}
else
{
$commandDB.CommandText = “SELECT d.name as DatabaseName FROM sys.databases d inner join sys.database_service_objectives dso on d.database_id = dso.database_id WHERE dso.elastic_pool_name = ‘” + $ElasticDBPoolName + “‘ ORDER BY d.name”
}
$ReaderDB = $commandDB.ExecuteReader();
while($ReaderDB.Read())
{
[void]$DbsArray.Add($ReaderDB.GetValue(0).ToString())
logMsg(“Database Name selected:” + $ReaderDB.GetValue(0).ToString()) (1)
}
$ReaderDB.Close();
$SQLConnectionSource.Close()
}
else
{
$DbsArray.Add($DB)
}
for($iDBs=0;$iDBs -lt $DbsArray.Count; $iDBs=$iDBs+1)
{
logMsg(“Connecting to database..” + $DbsArray[$iDBs]) (1)
$SQLConnectionSource = GiveMeConnectionSource($DbsArray[$iDBs]) #Connecting to the database.
if($SQLConnectionSource -eq $null)
{
logMsg(“It is not possible to connect to the database ” + $DbsArray[$iDBs] ) (2)
exit;
}
logMsg(“Connected to database..” + $DbsArray[$iDBs]) (1)
$CheckStatistics=0
$CheckIndexesAndStatistics=0
$CheckMissingIndexes=0
$CheckScopeConfiguration=0
$CheckStatusPerResource=0
$CheckStatusPerTable=0
$CheckQueryStats=0
$FileName=Remove-InvalidFileNameChars($DbsArray[$iDBs])
$CheckStatistics = CheckStatistics $SQLConnectionSource ($sFolderV + $FileName + “_CheckStatistics.Txt”) ($sFolderV + $FileName + “_CheckStatistics.Task”) (3600)
$CheckIndexesAndStatistics = CheckIndexesAndStatistics $SQLConnectionSource ($sFolderV + $FileName + “_CheckIndexesStatistics.Txt”) ($sFolderV + $FileName + “_CheckIndexesStatistics.Task”) (3600)
$CheckMissingIndexes = CheckMissingIndexes $SQLConnectionSource ($sFolderV + $FileName + “_CheckMissingIndexes.Txt”) ($sFolderV + $FileName + “_CheckMissingIndexes.Task”) (3600)
$CheckScopeConfiguration = CheckScopeConfiguration $SQLConnectionSource ($sFolderV + $FileName + “_CheckScopeConfiguration.Txt”) ($sFolderV + $FileName + “_CheckScopeConfiguration.Task”) (3600)
$CheckStatusPerResource = CheckStatusPerResource $SQLConnectionSource ($sFolderV + $FileName + “_ResourceUsage.Txt”) (3600)
$CheckStatusPerTable = CheckStatusPerTable $SQLConnectionSource ($sFolderV + $FileName + “_TableSize.Txt”) (3600)
$CheckQueryStats=CheckQueryStats $SQLConnectionSource ($sFolderV + $FileName + “_QueryStats.Txt”) (3600)
$TotalCheckStatistics=$TotalCheckStatistics+$CheckStatistics
$TotalCheckIndexesAndStatistics=$TotalCheckIndexesAndStatistics+$CheckIndexesAndStatistics
$TotalCheckMissingIndexes=$TotalCheckMissingIndexes+$CheckMissingIndexes
$TotalCheckScopeConfiguration=$TotalCheckScopeConfiguration+$CheckScopeConfiguration
$TotalCheckStatusPerResource = $TotalCheckStatusPerResource + $CheckStatusPerResource
$TotalCheckStatusPerTable = $TotalCheckStatusPerTable + $CheckStatusPerTable
$TotalCheckQueryStats=$TotalCheckQueryStats+$CheckQueryStats
logMsg(“Closing the connection and summary for….. : ” + $DbsArray[$iDBs]) (3)
logMsg(“Number of Issues with statistics : ” + $CheckStatistics ) (1)
logMsg(“Number of Issues with statistics/indexes : ” + $CheckIndexesAndStatistics ) (1)
logMsg(“Number of Issues with Scoped Configuration : ” + $CheckScopeConfiguration ) (1)
logMsg(“Number of Issues with Missing Indexes : ” + $CheckMissingIndexes ) (1)
logMsg(“Number of Resource Usage : ” + $CheckStatusPerResource ) (1)
logMsg(“Number of Tables Usage : ” + $CheckStatusPerTable ) (1)
logMsg(“Number of Query stats : ” + $CheckQueryStats ) (1)
$SQLConnectionSource.Close()
}
Remove-Variable password
logMsg(“ReadScale-Out Performance Collector Script was executed correctly”) (3)
logMsg(“Total Number of Issues with statistics : ” + $TotalCheckStatistics ) (1)
logMsg(“Total Number of Issues with statistics/indexes : ” + $TotalCheckIndexesAndStatistics ) (1)
logMsg(“Total Number of Issues with Scoped Configuration : ” + $TotalCheckScopeConfiguration ) (1)
logMsg(“Total Number of Issues with Missing Indexes : ” + $TotalCheckMissingIndexes ) (1)
logMsg(“Total Number of Resource Usage : ” + $TotalCheckStatusPerResource ) (1)
logMsg(“Total Number of Tables Usage : ” + $TotalCheckStatusPerTable ) (1)
logMsg(“Total Number of Query Stats : ” + $TotalCheckQueryStats ) (1)
}
catch
{
logMsg(“ReadScale-Out Performance Collector Script was executed incorrectly ..: ” + $Error[0].Exception) (2)
}
finally
{
logMsg(“ReadScale-Out Performance Collector Script finished – Check the previous status line to know if it was success or not”) (2)
}
Disclaimer: This script is provided as an example and should be used at the user’s own risk. It must be thoroughly tested before being used in a production environment.
Microsoft Tech Community – Latest Blogs –Read More
Deleted SharePoint folders keep reappearing
We are having problems with a number of folders in a SharePoint site accessing via a link in OneDrive which seem to have multiple lives. When we delete them from one user’s laptop (OneDrive app) or Via the web ui, then other user’s laptops recreate the soon after. This happens whether or not there are files in the folders.
I have today had to re-delete 100s of folders. Each time I do, another user’s laptop puts them back again. Sometimes the recreated folders are tagged with the user’s laptop name as a tag eg: FolderName-ComputerName – I think this is when the original FolderName was already re-created by another user’s laptop.
No sync errors are reported on the user’s laptops.
There is no “odd” configuration. All the users are “Members” of the site.
We’ve had this happen for one or two folders in the past but in the last two days it’s gone crazy.
Any clues about what’s happening and how to stop it?
We are having problems with a number of folders in a SharePoint site accessing via a link in OneDrive which seem to have multiple lives. When we delete them from one user’s laptop (OneDrive app) or Via the web ui, then other user’s laptops recreate the soon after. This happens whether or not there are files in the folders.I have today had to re-delete 100s of folders. Each time I do, another user’s laptop puts them back again. Sometimes the recreated folders are tagged with the user’s laptop name as a tag eg: FolderName-ComputerName – I think this is when the original FolderName was already re-created by another user’s laptop.No sync errors are reported on the user’s laptops.There is no “odd” configuration. All the users are “Members” of the site.We’ve had this happen for one or two folders in the past but in the last two days it’s gone crazy.Any clues about what’s happening and how to stop it? Read More
Migration of Inactive Users
Hi Team,
We recently received a new request for Migration of Inactive Users from Source Microsoft365 tenant to Destination Microsoft 365 tenant we need to automate this migration can anybody recommend the best way to achieve this.
Need to Migrate the Mailbox Data and OneDrive Data of Users
Hi Team,We recently received a new request for Migration of Inactive Users from Source Microsoft365 tenant to Destination Microsoft 365 tenant we need to automate this migration can anybody recommend the best way to achieve this.Need to Migrate the Mailbox Data and OneDrive Data of Users Read More
Request for Information: Auto-Refresh Feature for Microsoft Teams Side Panel Content
I hope this message finds you well. I am reaching out to express my gratitude for the continuous support provided in integrating the Microsoft Teams application into our meetings. The functionality has been exceptional, enhancing our collaborative experiences seamlessly.
Currently, we are exploring further enhancements to our custom applications, specifically focusing on the side panel within Microsoft Teams meetings. Our aim is to ensure that the content remains dynamically updated, offering attendees real-time access to relevant information.
In this regard, I am keen to inquire about the availability of an auto-refresh or manual refresh feature within the Microsoft Teams side panel. Such functionality would greatly benefit our attendees, allowing them to stay up-to-date with meeting app content even as organizers make updates.
Could you kindly provide insight into whether such features exist within the Microsoft Teams platform? Additionally, any guidance or best practices on implementing dynamic content updates within the side panel would be highly appreciated.
Thank you once again for your ongoing support and assistance. We look forward to your prompt response and further collaboration in optimizing our Microsoft Teams experience.
Warm regards,
Sukesh PK.
I hope this message finds you well. I am reaching out to express my gratitude for the continuous support provided in integrating the Microsoft Teams application into our meetings. The functionality has been exceptional, enhancing our collaborative experiences seamlessly. Currently, we are exploring further enhancements to our custom applications, specifically focusing on the side panel within Microsoft Teams meetings. Our aim is to ensure that the content remains dynamically updated, offering attendees real-time access to relevant information. In this regard, I am keen to inquire about the availability of an auto-refresh or manual refresh feature within the Microsoft Teams side panel. Such functionality would greatly benefit our attendees, allowing them to stay up-to-date with meeting app content even as organizers make updates. Could you kindly provide insight into whether such features exist within the Microsoft Teams platform? Additionally, any guidance or best practices on implementing dynamic content updates within the side panel would be highly appreciated. Thank you once again for your ongoing support and assistance. We look forward to your prompt response and further collaboration in optimizing our Microsoft Teams experience. Warm regards, Sukesh PK. Read More
Constant Noninteractive sign in attempts from Microsoft IPs
In noninteractivesigninlogs, we’re seeing a bunch of attempts made to sign in to our admin accounts rejected with error codes 500131 and 500133 coming from 4.231.207.170 and 2a01:111:f400:fe13::100 (Microsoft datacentre IPs), device type “Windows 10”, Resources are ComplianceAuthServer/Office 365 Exchange Online.
What are we seeing here, is this a misconfiguration on the Microsoft side, or an attack?
In noninteractivesigninlogs, we’re seeing a bunch of attempts made to sign in to our admin accounts rejected with error codes 500131 and 500133 coming from 4.231.207.170 and 2a01:111:f400:fe13::100 (Microsoft datacentre IPs), device type “Windows 10”, Resources are ComplianceAuthServer/Office 365 Exchange Online.What are we seeing here, is this a misconfiguration on the Microsoft side, or an attack? Read More
Inactive Users PST Migration from Tenant to Tenant M365
Is there a way I can migrate an inactive PST to another Office 365 tenant? Any suggestions on how I can move PST files to another tenant using eDiscovery?
Is there any PowerShell script that can upload the PST directly into another Tenant data life cycle management Import job for PST.
can AZ copy -copy the data from eDiscovery Export Key to Target Tenant SAS URL.
Is there a way I can migrate an inactive PST to another Office 365 tenant? Any suggestions on how I can move PST files to another tenant using eDiscovery? Is there any PowerShell script that can upload the PST directly into another Tenant data life cycle management Import job for PST.can AZ copy -copy the data from eDiscovery Export Key to Target Tenant SAS URL. Read More
Editable forms after entering data
Hello to everyone.
I haven’t used MS Access for things other than database management in over 10 years. Recently, I’ve found the need to create some data management forms for different projects. Therefore, I apologize if my question seems simple and old, but I have failed to find videos/tutorials explaining what I’m looking for specifically.
The idea is to have a form for different users to enter their respective information. When first entered, ALL of these forms will be incomplete due to the nature of the associated processes. What I’d like is for the users to be able to lookup the forms they had filled out originally and complete them whenever they acquire the missing information.
Each form would have a way to be identified in a unique fashion using the workplace’s ID system, so that part is a non-issue.
Any help would be greatly appreciated.
Hello to everyone. I haven’t used MS Access for things other than database management in over 10 years. Recently, I’ve found the need to create some data management forms for different projects. Therefore, I apologize if my question seems simple and old, but I have failed to find videos/tutorials explaining what I’m looking for specifically. The idea is to have a form for different users to enter their respective information. When first entered, ALL of these forms will be incomplete due to the nature of the associated processes. What I’d like is for the users to be able to lookup the forms they had filled out originally and complete them whenever they acquire the missing information. Each form would have a way to be identified in a unique fashion using the workplace’s ID system, so that part is a non-issue. Any help would be greatly appreciated. Read More
Enrolling shared or kiosk Windows devices?
Hi,
We need to deploy a number of shared Windows computers and Kiosk computers. I have found plenty of information on how to build profiles and manage them within Intune, but what I can’t seem to find is any information on how to get them Into Intune. It seems pretty straight forward to bring a laptop into Intune that will be used by a specific user, but not a device that will be shared by multiple users.
Can anyone point me towards some step-by-step procedures or video demonstrations for how to bring a hybrid joined device into Intune that isn’t registered to a specific user?
Thanks in advance!
Hi, We need to deploy a number of shared Windows computers and Kiosk computers. I have found plenty of information on how to build profiles and manage them within Intune, but what I can’t seem to find is any information on how to get them Into Intune. It seems pretty straight forward to bring a laptop into Intune that will be used by a specific user, but not a device that will be shared by multiple users. Can anyone point me towards some step-by-step procedures or video demonstrations for how to bring a hybrid joined device into Intune that isn’t registered to a specific user? Thanks in advance! Read More
Purview Adoption KIT
Hi!
Anyone has an e-mail template to communicate end user about Purview?
Hi! Anyone has an e-mail template to communicate end user about Purview? Read More
Try the Next-gen GP Azure SQL Managed Instance for free
automated backups and patching,
built-in high availability (within single and multi-zone deployments) for ensuring business continuity backed up with 99.99% uptime SLA,
failover group setup for disaster recovery,
online management operations,
and much more.
All these capabilities are one click away from you as they are provided out of the box without need for complex setups and configuration.
What is next-gen general purpose Azure SQL Managed Instance?
What are the key improvements of the next-gen general purpose tier?
Category
Item
Current GP
Next-gen GP
Improvement
Storage performance
Limits
Separate limits for each file
Shared limits for the instance
Easier to use, familiar model
5-10 ms
3-4 ms
2x lower I/O latency
Max data IOPS
30-50k IOPS
80k IOPS
60% better
Max log throughput
Per instance: 120 MB/s
Per DB: 22-65 MB/s
Per instance: 192 MB/s
Per DB: no limits
60% better
3x better
Storage limits
Max storage
16 TB
32 TB
2x better
Max number of DBs
100 DBs
500 DBs
5x better
Max number of files
280 per instance
4096 per database
Huge improvement!
How to try out the next-gen general purpose tier for free?
Free Azure SQL Managed Instance
Reduce costs by using dev/test subscription and start-stop feature
You are in the project phase where you don’t need an uptime SLA.
You are not charged for SQL license (cost optimization).
Your instance does not have to be online 24/7 so you can stop it out of the working hours (cost optimization).
Conclusion
The next-gen general purpose Azure SQL Managed Instance is a great option for anyone who needs a fully managed, secure, and scalable cloud database service with exceptional storage performance and limits, and more flexibility and control over the instance configuration. You can try out the next-gen general purpose tier for free or at a very low cost, by using the Free Azure SQL Managed Instance offering or dev/test subscription combined with start-stop capability. Don’t miss this opportunity to experience the benefits of the next-gen general purpose tier for your applications.
Useful links
Microsoft Tech Community – Latest Blogs –Read More
New on Microsoft AppSource: April 26-30, 2024
We continue to expand the Microsoft AppSource ecosystem. For this volume, 75 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
AInsight Analytics for Power BI: AInsight Analytics integrates Microsoft Azure OpenAI Assistant and chat data with Microsoft Power BI, offering visuals on sentiment analysis, engagement metrics, topics, and trends. It simplifies chat data analysis and enhances customer experience management. Gain insights into sentiment trends, customer satisfaction levels, and engagement patterns, empowering you to enhance AI-human interactions.
Automatic Import of EDI Orders: HubBroker’s expert electronic data interchange (EDI) managed services allow secure and seamless communication between trading partners and customers from Microsoft Dynamics 365 Business Central. The fast and convenient EDI integration imports orders directly from Dynamics 365 to your system in the desired format, ensuring improved data accuracy, enhanced visibility, and faster order processing.
Best Accounting & Bookkeeping Software by Moon Books: Automate billing processes with feature-rich billing software for a frictionless experience. The user-friendly interface allows for easy use by non-tech-savvy individuals, and invoices are automatically saved in cloud storage for easy access during tax season. Other features include online sales receipts, business expense reports, simplified tax filing, financial reports, online payments, and instant sharing. Ideal for accountants, treasurers, and financial executives.
BitFractal Transcriber Speech to Text (STT) API: The BitFractal speech to text application programming interface (API) transcribes audio clips into captions and transcriptions for various industries, supporting over 140 languages and dialects. It offers accurate transcriptions with profanity filter and customizable parameters. Available in data centers in the US, Europe, and Brazil, it can be used with Microsoft Power Automate, Azure Logic Apps, and orchestrators.
Bluebox CDMS for Quality Management: Bluebox’s controlled document management system (CDMS) offers automatic creation, storage, review, and archival of important business documents. It provides accuracy, consistency, compliance, version control, traceability, improved efficiency, and enhanced security. The CDMS has simple user access features, standard and consistent metadata classification, automated workflows, periodic review processes, task management, document acknowledgments tracking, and a powerful search engine.
Calven for Outlook: Calven for Microsoft Outlook is an add-in that helps manage hybrid work, optimize the office, and create personalized work experiences. It allows users to view available rooms, attach service requests to events, and book desks and amenities. The platform also lets users set their work preferences and access company services and resources.
ClusterSense – AI Segmentation of Points of Sale: ClusterSense is an artificial intelligence (AI) solution for segmenting points of sales according to purchasing behavior. It allows manufacturers, distributors, and retail networks adjust their offers and promotional activities to a specific client segment and its profile, as well as achieve sales or distribution goals faster and more effectively.
Conversational AI API for IVRs, SMS, and WhatsApp: BitFractal Conversational AI API combines text to speech, Microsoft Azure OpenAI, and speech to text in a single application programming interface (API) call. It supports multi-turn conversations, text, voice, and hybrid interactions, in over 140 languages. The API is easy to use and integrate, and its pricing is based on AI credits, which are consumed at every API request.
DeepSign Integration for SharePoint: DeepSign simplifies and digitizes the signature process through its integrated solution. Users can initiate the process directly within Microsoft OneDrive or SharePoint, with three different signature types available for legally compliant signing. The pay-per-use model and DeepID identification solution make it easy to use.
DKS 365 Project and Invoicing Operations: DKS 365 is an invoicing extension for Microsoft Dynamics 365 Business Central. It allows for different invoicing methods, such as down-payment, fixed-price, progress, and subscription invoicing. The app also features a dashboard for managing outstanding invoices. It supports both Essential and Premium editions of Business Central and is available in French and English.
FlexWork Manager: FlexWork Manager is a software tool that optimizes hybrid workspaces by integrating remote and on-site work through adaptable scheduling, real-time updates on employee locations, and automated workspace assignments. It also includes health guideline adherence and robust analytics for office utilization, making it essential for modern, flexible work environments.
Flux for Excel: Flux for Excel is an enterprise add-in that integrates live fair value curves for oil futures into Microsoft Excel spreadsheets. It allows market participants to stay informed and use accurate pricing from Onyx in their custom sheets. The add-in also includes settlement prices to match major future settles.
gulfHR: gulfHR is a cloud-based human resources (HR) platform that offers real-time data updates and access to employee information in the Middle East. It has an intuitive on-the-go functionality for employees and can be accessed from anywhere with an internet connection. The software can integrate with existing HR, finance, accounting, and time and attendance tracking systems.
Health Monitor Blendvenue: Health Monitor tracks workplace conditions and employee well-being using sensors and artificial intelligence (AI). It evaluates air quality, lighting, temperature, and noise levels, and syncs with wearable technology to monitor wellness indicators. Its user-friendly dashboard simplifies adoption of health-centric modifications, helping companies foster a healthier work environment.
LEMON HUB: LEMON HUB is an intelligence marketing automation platform that integrates data automation, intelligence, and visualization. It improves operational efficiency, data usage, and performance while reducing operational costs. It solves pain points such as data source integration, legal compliance, and real-time and accurate data.
LingoSub – Learn languages by watching videos with AI-powered translations: LingoSub offers a language learning solution through video subtitles. With artificial intelligence (AI) powered in-context translations, it follows the comprehensible input method for faster proficiency. One subscription grants access to six languages and thousands of videos.
Maileva for Word: Maileva is an online mailing service that offers both physical and electronic delivery options from Microsoft Word. It saves time and money by eliminating printing, postage, and consumables. The service provides real-time tracking and secure delivery with legal value. Maileva is a subsidiary of Docaposte and La Poste Group, with over 20 years of experience in mail outsourcing.
Modelmap: Modelmap is a tool that analyzes spreadsheet calculations and presents the data in a clear and intuitive way. Designed for professionals such as investment bankers, financial modelers, tax consultants, auditors, and business development managers, it’s fully integrated with Microsoft Excel and allows for easy manipulation of data.
Moon HRM: HR Management and Payroll Software: Moon HRM is an all-in-one human resources (HR) and employee management software designed for businesses with more than 15 full-time employees. It offers employee onboarding, leave and attendance management, time tracking, project management, and screen monitoring. It also offers Basecamp integration, activity tracking, and biometric access.
Multi-Currency GL: The Multi-Currency GL app adds full multi-currency functionality to Microsoft Dynamics 365 Business Central’s general ledger, allowing for revaluation of foreign currency balances in balance sheet accounts and compliance with IAS 21 and ASC 830. The app also includes a simplified exchange rate page and supports Essential and Premium editions in Canada, the United States, and the United Kingdom.
myCloud OKTicket: Available in Spanish, myCloud OKTicket is a connector between OKTicket app and Microsoft Dynamics 365 Business Central, allowing for quick and effective transfer of expense information to Business Central. It provides bidirectionality, security, and real-time access to expense information, optimizing expense management and reducing time and costs.
NIST CSF Assessment and Planning: Mitovia offers an online assessment and planning tool pre-loaded with National Institute of Standards and Technology cybersecurity framework (NIST CSF), best practices, and risk factors to reduce compliance costs, improve risk posture, and demonstrate progress. The tool supports the full life cycle of assessing, planning, and managing cybersecurity capabilities and risk exposure.
Restaurant and Retail Point of Sale by Moon POS: Moon POS allows restaurant and retail owners to manage their businesses efficiently. Customers can scan a quick response (QR) code to browse products, confirm orders, and make online payments. It also includes an in-built receipt maker, expense tracking, and inventory management features. It is user-friendly and offers an intuitive dashboard for managing multiple business operations.
Revolutio.Ai for Outlook: Revolutio.Ai’s add-in for Microsoft Outlook streamlines matter management for legal teams by converting and uploading emails as portable document format files (PDFs) with attachments directly into specified matters. It integrates smoothly with existing workflows and benefits small to large legal firms, in-house legal teams, and solo practitioners. This tool reduces document management time and effort, allowing legal professionals to focus on core activities.
SMX 365: SMX 365 offers dual-layer security with Microsoft 365 threat protection, global and regional threat detection, and machine learning algorithms to protect against phishing, malware, and spam. It also provides improved deliverability, easy cloud-based management, and dynamic email workflow with data loss protection. SMX 365 complements Microsoft 365 and maintains full productivity.
SMX Archiving: SMX Archiving is a solution for compliance and internal investigations that archives all email sent and received by an organization. It offers swift data access and recovery, unified searching, and full regulatory compliance. The pricing is per user/per month subscription with no hidden costs.
Summize Inbox Assistant (Austria): Summize revolutionizes contract management with its conversational software that streamlines processes and provides insights. The Summize assistant allows users to: upload, create, and request legal review of contracts in formats like PDF and docx; and use templates.
Summize Inbox Assistant (Switzerland): Summize revolutionizes contract management with its conversational software that streamlines processes and provides insights. The Summize assistant allows users to: upload, create, and request legal review of contracts in formats like PDF and docx; and use templates.
Summize Inbox Assistant (US): Summize revolutionizes contract management with its conversational software that streamlines processes and provides insights. The Summize assistant allows users to: upload, create, and request legal review of contracts in formats like PDF and docx; and use templates.
TreppInsights Add-In for Excel: The TreppInsights add-in for Microsoft Excel provides commercial real estate data on property location, debt, financial benchmarks, and risk assessment. It enhances valuation, underwriting, monitoring, and benchmarking capabilities in Excel.
Vuurmans Custom Polar Area Chart: A polar area chart allows for double categorization and the addition of two measure variables. It uses a standard scale of 0-100 for efficient interpretation of percentages.
Wise Matrix Loan Connector: The Wise Matrix Loan Connector imports securities transactions from Five Degrees matrix loan system, saving time and optimizing work when recording securities movements. It supports both Essential and Premium editions of Microsoft Dynamics 365 Business Central and is available in Icelandic and English.
Wordlit: Wordlit simplifies natural language processing (NLP) models by transforming text into easy-to-understand knowledge graphs. It enhances the understanding and research of NLP technologies by providing a straightforward visualization of text analysis. Wordlit offers a unique visual approach to understanding the mechanics of NLP, making it easier for researchers and enthusiasts to grasp complex concepts.
Go further with workshops, proofs of concept, and implementations
BizApps Design and Discovery: 2-Week Engagement: Wild Tech offers a discovery and design consultation to deliver project success. This deep dive into business processes identifies key workflows and customer touchpoints, confirming reporting requirements and predicting project costs and timeframes. Deliverables include a solution document, gap analysis, project plan, and matrix for stakeholder communication. This sets the stage for a successful project and drives efficiency and innovation.
Copilot Consulting: This service from LG CNS offers change management for workplace transitions to improve copilot adoption. It includes diagnosing the current workplace, designing a future image, selecting Microsoft 365 licenses, introducing licenses in stages, and supporting change management activities.
Copilot for Microsoft 365 Readiness Workshop: Copilot for Microsoft 365 offers AI-powered features to streamline tasks, automate workflows, and enhance collaboration. Gryphon Consulting’s Copilot for Microsoft 365 Readiness Workshop assesses an organization’s productivity bottlenecks and optimizes its Microsoft 365 environment for maximum efficiency and Copilot adoption.
Copilot for Security: 5-Day Enablement: Microsoft Copilot for Security uses AI to enhance security solutions. The assessment by Netsurit identifies gaps and opportunities to improve existing security solutions, transfers knowledge to the security team, and estimates costs for implementation.
Copilot Readiness Assessment: Nexigen offers a Copilot for Microsoft 365 readiness assessment to help organizations prepare for AI implementation. The assessment covers business, technology, and AI strategies, as well as culture and governance. The process includes an introductory call, questionnaire, assessment report, and implementation plan.
Dynamics 365 Sales Implementation: 1-Week Assessment: This Microsoft Dynamics 365 Sales assessment offered by OntargIT will evaluate cost and terms, build an implementation path, and prepare teams. The assessment includes feature lists, implementation cost estimation, timeline, risk mitigation, solution blueprint, and project charter draft. The typical assessment schedule involves preliminary gathering of requirements, interviews with key users, and finalization of documentation.
ManualMate: 1-Week Project: ManualMate is an AI-driven expert system that provides instant access to technical manuals and expert systems. It streamlines technical queries, reduces downtime, and increases productivity. The target audience includes technical support teams, field service technicians, engineers, manufacturing operatives, quality assurance analysts, and training and development managers.
Microsoft Fabric: 1-Week Proof of Concept: Microsoft Fabric offers a lake-centered SaaS solution that combines data integration, engineering, and analysis in one system. The proof of concept (PoC) by areto group evaluates the platform’s benefits by providing a first use case. The workshop includes a use-case session, data integration, semantic model development, visualization, and conclusion. This offer is only available in German.
Modern Workplace Advisory Services: Briefing: Capgemini’s modern workplace advisory services help clients maximize their investment in Microsoft 365 by improving collaboration, productivity, and colleague experience. It offers strategy and operating model advisory, workplace experience and adoption, modern ways of working and productivity, data and technology enablement, and labs and accelerators.
Power Automate for Accounting and Finance: 1-Month Implementation: Microsoft Power Automate is an intelligent digital automation platform that streamlines repetitive tasks, allowing accounting and finance employees to focus on more strategic work. Smartbridge offers experienced staff and professional services to support Power Automate projects, including automation of invoice and payment processing, customer onboarding, and compliance tracking. It also provides documentation and support for implementation.
PwC Manufacturing Ready Capabilities: PwC’s offers a cloud-based enterprise resource planning (ERP) solution for original equipment manufacturers (OEMs) in discrete manufacturing. Built on Microsoft Dynamics 365, it offers end-to-end process and data integration, real-time material flow tracking, improved production processes with analytics and machine learning, and improved inventory and material handling.
Simply Business Central: This consultation offers a rapid implementation of Microsoft Dynamics 365 Business Central’s core functionality for growing organizations. Eide Bailly offers expertise in implementing business applications to help create a foundation for your digital future. It brings a business-focused conversation and technology alignment for the greatest business value.
TCS Cloud Operations for Digital Workplace: 1-Month Implementation: TCS Cloud Operations uses the machine first approach to provide smart managed services in hybrid cloud environments. It offers incident management, change management, problem management, service request management, and more. The service also includes support for Microsoft 365 applications and services, virtualization and device management, and Copilot support.
Teams and Copilot: 2-Hour Workshop: This workshop from ATN GROUPE teaches users how Copilot for Microsoft 365 in Microsoft Teams improves productivity and collaboration. It covers key features, accessing Copilot, and differences between Copilot and Teams Premium AI. The workshop is suitable for Teams users, IT professionals, and anyone interested in AI in Teams. This offer is available in French.
Value and Competitive Advantage: Capgemini offers a value assessment methodology to benchmark organizations against others and identify areas for improvement. With Microsoft Dynamics 365, businesses can transform their sales, service, marketing, finance, operations, or supply chain functions. The assessment provides a quantified and qualified impact, business case, and IT roadmap for new implementations.
Value Proposal of Copilot for Microsoft 365: Copilot for Microsoft 365 is a productivity tool that uses large language models and AI algorithms to comprehend, summarize, predict, and generate content. It integrates with Microsoft Graph content and Microsoft 365 applications to provide real-time intelligent assistance, enhancing users’ creativity, productivity, and capabilities. This consultation with Minsait has four phases: preparation, onboard and engage, generate impact, and evolution.
Contact our partners
Arcadier Cloud Marketplace Solution for Enterprises
Customer-Driven Marketing Solution for Dynamics 365
IT Monitoring with Power BI Portal
Patient Safety Narrative Creation
POS and Unified Commerce Platform
SalesLife 365 for Retail and Point of Sale
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More